S
Steve
HYCH
My question is:
I have a range from H2:I32, within this range i have values of 1 and 0
spread throughout,
is it possible to run a vba macro to check for a 1 and then colour the
cell red,
i know how to use the 'Pattern.Solid Colorindex and numbers, but am
having very little luck with the actual code to check this range,
would prefer to have this running as a worksheet change event
Hych
Steve
My question is:
I have a range from H2:I32, within this range i have values of 1 and 0
spread throughout,
is it possible to run a vba macro to check for a 1 and then colour the
cell red,
i know how to use the 'Pattern.Solid Colorindex and numbers, but am
having very little luck with the actual code to check this range,
would prefer to have this running as a worksheet change event
Hych
Steve