Link to home
Start Free TrialLog in
Avatar of Gwynneth Taylor
Gwynneth TaylorFlag for United Kingdom of Great Britain and Northern Ireland

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.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have tried using conditional formatting but it only colours the cells not the full rows.
just use the Format Painter and paint it across the whole rows
Avatar of Rgonzo1971
Rgonzo1971

Hi,

or you could simply use
=$G1="Word"

Open in new window

1 is for the first row applied to
and apply to the whole row
for example =$1:$25

Regards
Avatar of Gwynneth Taylor

ASKER

Excellent thank you. Worked first time.
You're Welcome Gwynneth! Glad I was able to help.