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. . |
All times are GMT +1. The time now is 04:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com