Hi Seve

Look at CF
http://www.contextures.com/xlCondFormat01.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in message ...
Good day,

I have a spreadsheet that I want to loop through a range and change the
BackColor fill of a row to a user defined color if the the row contains a
flag. In other words,

If cell a1 contains "Yes", then color the row blue,""
If cell b1 contains "Yes", then color the row blue,""

Any help,

Thanks,