Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that will change the color of a cell #1 when a Y o.
David,
do you definitely need a macro for this, as the same result could be achieved using conditional formatting. If we assume you want B1 to go red when A1 = Y: go to the Format menu Conditional Formatting. From the dropdown select "Formula Is", then type =A1="Y"; select the "Format" button and choose the conditions you require. If you really want a macro to do this, post back. Cheers, Pete -----Original Message----- I need a Macro in Excel that will change the color of cell #1 when a Y or N is entered into cell #2. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the Color of a Cell through a Macro | Excel Discussion (Misc queries) | |||
Macro to change cell color | Excel Discussion (Misc queries) | |||
I need a macro that will change the color of a cell #1 when a Y o. | Excel Programming | |||
I need a macro that will change the color of a cell #1 when a Y o. | Excel Programming | |||
I need a macro that will change the color of a cell #1 when a Y o. | Excel Programming |