I have a column with a range of dates corresponding to when an item was tested and would like to automatically change the colour in individual cells in that column 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
Bookmarks