User types in date in a msgbox of which year is pulled out for A1.
Was trying to develope conditional formatting for a set of selected
cells based on A1 (therefore, it's absolute as $A$1) where this year
is one colour, next year is another and following year is another - in
keeping with the 3 conditions we're allowed to have in conditional
formatting. I figure that in 4 years time, we can cycle through the
same 3 colours again with no problem.

But I'm not any closer to getting something that works even after much
searching through the archives.

The goal, then, is if I'm typing in today's date in user box, 2005 is
put in A1 and all pertinent cells are light orange. Yet if I type in
a starting date in 2006, those cells will be light blue, and anything
in 2007 would be in light green. 2008 would start back at light
orange, etc.

Can something like this be accomplished?

Thanks much.



MERRY CHRISTMAS! :oD