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,

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,