Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell formating | Excel Discussion (Misc queries) | |||
conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Formating cell to 1000 | Charts and Charting in Excel | |||
color formating ontingenton upon another cell? | Excel Discussion (Misc queries) |