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