Solved How to apply conditional formatting in excel 2016

May 18, 2016 at 09:55:01
Specs: Windows 7
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


See More: How to apply conditional formatting in excel 2016

Report •

#1
May 18, 2016 at 10:27:16
✔ Best Answer
Look at this HOW-TO:

http://www.computing.net/howtos/sho...

Also, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question