Conditional formatting excel

Gwynneth Taylor
Gwynneth Taylor used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Assuming your text is in G Col and you want to highlight from A to M. Try below:
=INDIRECT("G"&ROW())="Gwen"

Open in new window

Change the text Gwen with the text you want for conditional formatting.
Apply range from A1:M20 or whatever range you may have
Check below image:
Conditional Formatting
Ryan ChongSoftware Team Lead

Commented:
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
Top Expert 2016

Commented:
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

Author

Commented:
Excellent thank you. Worked first time.
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
You're Welcome Gwynneth! Glad I was able to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial