|Column G has a date ex: May 01/2015(last calibrated) and Column I has a date of May 01/2016 (next calibration due). Since this date is past I need the cell to turn red. I am doing calibration workbook of hundreds of tools. I need all past to go red, all one month away yellow and within the existing month orange.|
all other cells A,B,C etc have information filled in according to tool, number etc. How can i apply conditional formatting to workbook for the 3 colours?
message edited by customgirl