Conditional Formating 4 conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top