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?