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.
CERTIFIED EXPERT
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
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