Conditional Formating 4 conditions

[Roy]

I need to set up 4 conditions. Column F is Date Due, column G Date Complete,
and Column H is Status.

I want column H to change pattern color and insert the color name if column
F is past the Date Due to be red, yellow if 5 days before the date due, white
if date due is on target, and green if a date is entered into the date
complete column.

My formula is
if(f2<=today(),"RED",if(f2<=today()+5,"YELLOW",if(f2<=today()+365,"WHITE,if(g2<>f2,"GREEN"

How can I do this? the red, yellow, and white seem to work, but I can't get
the green to work.

Roy

[Maurice]

First Part
=IF(E1>0,"GREEN",IF(F1<=TODAY(),"RED",IF(F1<=TODAY()+5,"YELLOW",IF(F1<=TODAY()+365,"WHITE","GREEN")))) will set the text, then use conditional formating for the column to identify the "RED", "YELLOW" and "GREEN" components, the cell should be formatted as WHITE already, the last "GREEN" in the statement could be anything you want.

Should also mention adjust references as necessary, the first part of the statement allows any value, so even if you don't enter a date but mark it as complete it will still work.

IF statments rely on finding the first 'TRUE' value, all the rest are then disregarded