How to use conditional format to change the color of rows | Message 4 of 4 | TechRepublic

Discussion on:

Use conditional formatting to add shading to rows or columns in an Excel worksheet

View entire thread

Message 4 of 4

« Prev

0 Votes

+ -

How to use conditional format to change the color of rows

I have a situation as following, can somebody help me?

if cell A1= AA, then the whole row change color to red,
if cell A1=AB then the whole row change color to yellow.

Thanks

Posted by evelynyguo

28th Nov 2011