|In Excel 2010 I have a speadsheet listing the dates in which employees have obtained their various certifications. Some cells have no dates, because the employee doesn't have that certification. The certifications are the column headings and they expire at different rates (1yr, 3yr, or 5yr). If there is no date I would like the cell to remain white. I would like the cell to turn red if the certification date has expired. I would like the cell to turn yellow if the expiration date is approaching within 2 months. I am using the following formulas: |
=IF(TODAY()>=(M7,12),TRUE,FALSE) -----turns RED
=IF(TODAY()>=(M7,10),TRUE,FALSE) ------turns YELLOW
These fomulas work, however If I have no data in the cells they turn red (or yellow if I delete the red fomula). I would like the cells to remain white if there is no data in the cell (the cells will remain white if the date is farther out than 2 months). Do I need to add another formula or do I need to modify my formulas?