cell formating
 

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?

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

"Pat DeStasio" wrote:

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?

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

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

"Pat DeStasio" wrote:

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?