We help IT Professionals succeed at work.

Conditional formatting excel

106 Views
Last Modified: 2017-03-23
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

Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT

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
CERTIFIED EXPERT
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
CERTIFIED EXPERT
Distinguished Expert 2018

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