cell formating

P

Pat DeStasio

Does anyone know if you can add a line or two to a macro to look through
several columns of data, find the cells that are formatted yellow and change
the yellow to red?
 
K

Kassie

Yes you can. Obviously though, this will be based on the cell meeting
certain criteria. Why not use conditional formatting to do this?
 
P

Pat DeStasio

Thanks Kassie, This will be my first attempt at conditional formatting. I'll
play around it some, thanks again
 
Top