G
Guest
I have a spread sheet that contains 3 date columns, column A is open date,
column F is due date, and column G is complete date, and column H is Status
(RED,YELLOW,GREEN). I want column H to change to RED when the due date is
overdue, to change to YELLOW when the due date is within 5 days of being
overdue, and to change to GREEN when 6 days or less of the due date. How can
I do this? The formula that I have in the cell is
=IF(F9="","",IF(F9="",IF(TODAY()>F9-5,"RED",""),IF(TODAY()>=F9-5,"YELLOW","GREEN")))
column F is due date, and column G is complete date, and column H is Status
(RED,YELLOW,GREEN). I want column H to change to RED when the due date is
overdue, to change to YELLOW when the due date is within 5 days of being
overdue, and to change to GREEN when 6 days or less of the due date. How can
I do this? The formula that I have in the cell is
=IF(F9="","",IF(F9="",IF(TODAY()>F9-5,"RED",""),IF(TODAY()>=F9-5,"YELLOW","GREEN")))