Reply to Message

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