P
Pete McCosh
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
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