I need to change the background color for c5:c29 based on the value (1 or 2) in cell c4 and if c8 is a (1 or 2) then change c9:c29 and if c18 is a (1 or 2) then change c19:c29 and this will happen maybe 100 different times on this worksheet.
I did something like this a long time ago but can get this to work now?
Thanks for any pointers.
BMD
I did something like this a long time ago but can get this to work now?
Thanks for any pointers.
BMD