asked on Conditional formatting excel
Hi
Can someone please advise the easiest way to colour rows which have a specific name in a column in excel. I have tried using conditional formatting but it only colours the cells not the full rows.
Can someone please advise the easiest way to colour rows which have a specific name in a column in excel. I have tried using conditional formatting but it only colours the cells not the full rows.
Microsoft ExcelMicrosoft Office
Last Comment
Shums Faruk
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
just use the Format Painter and paint it across the whole rows
Hi,
or you could simply use
and apply to the whole row
for example =$1:$25
Regards
or you could simply use
=$G1="Word"
and apply to the whole row
for example =$1:$25
Regards
ASKER
Excellent thank you. Worked first time.
You're Welcome Gwynneth! Glad I was able to help.