I have a column with a range of dates corresponding to when an item was
tested and would like to automatically change the colour depending on
which month it was tested. Jan-Mar = red, Apr-Jun= green, Jul-Sep=
blue and Oct-Dec= yellow. No date = no colour. Anyone have any
suggestions? Do I need to run a macro or is there a simpler way?

Thanks

Andy


--
andy75
------------------------------------------------------------------------
andy75's Profile: http://www.excelforum.com/member.php...o&userid=30177
View this thread: http://www.excelforum.com/showthread...hreadid=498604