The formula i have entered does not work for all conditions. Here is the
formula i have entered and works for 2 conditions but not all 4.

=IF(A12=0,"",IF(S12=0,"",IF(s12<=R12,"GREEN",IF(S1 2R12,"RED/LATE",IF(R12<=TODAY()+3,"YELLOW","WHITR")))))

A12, R12, S12 contain dates and Column T is a status column. If no date is
in column A then i want column T to be blank. And if column S date is blank,
then i want column T to be white (on target for due date, column R), or
yellow (3 days before due date). If column S is R it should be RED/LATE,
or if < should be GREEN. The red and green work fine, but i can not get the
yellow or white to work. What can i do?

This might be a good application for a conditional format. Access it using
FORMAT - Conditional Formatting. It will format the cells selected and you
can change the color of the cells, among other things.

"Roy" wrote:

The formula i have entered does not work for all conditions. Here is the
formula i have entered and works for 2 conditions but not all 4.

=IF(A12=0,"",IF(S12=0,"",IF(s12<=R12,"GREEN",IF(S1 2R12,"RED/LATE",IF(R12<=TODAY()+3,"YELLOW","WHITR")))))

A12, R12, S12 contain dates and Column T is a status column. If no date is
in column A then i want column T to be blank. And if column S date is blank,
then i want column T to be white (on target for due date, column R), or
yellow (3 days before due date). If column S is R it should be RED/LATE,
or if < should be GREEN. The red and green work fine, but i can not get the
yellow or white to work. What can i do?

Contitional formating is set up (1st condition cell = RED/LATE, 2nd condition
cell= YELLOW, 3rd condition cell = GREEN). am i doing something incorrectly?

"Barb R." wrote:

This might be a good application for a conditional format. Access it using
FORMAT - Conditional Formatting. It will format the cells selected and you
can change the color of the cells, among other things.

"Roy" wrote:

The formula i have entered does not work for all conditions. Here is the
formula i have entered and works for 2 conditions but not all 4.

=IF(A12=0,"",IF(S12=0,"",IF(s12<=R12,"GREEN",IF(S1 2R12,"RED/LATE",IF(R12<=TODAY()+3,"YELLOW","WHITR")))))

A12, R12, S12 contain dates and Column T is a status column. If no date is
in column A then i want column T to be blank. And if column S date is blank,
then i want column T to be white (on target for due date, column R), or
yellow (3 days before due date). If column S is R it should be RED/LATE,
or if < should be GREEN. The red and green work fine, but i can not get the
yellow or white to work. What can i do?

YOu can only set conditions for the cells you are formatting. You can't base
the results on other cells.

"Roy" wrote:

Contitional formating is set up (1st condition cell = RED/LATE, 2nd condition
cell= YELLOW, 3rd condition cell = GREEN). am i doing something incorrectly?

"Barb R." wrote:

This might be a good application for a conditional format. Access it using
FORMAT - Conditional Formatting. It will format the cells selected and you
can change the color of the cells, among other things.

"Roy" wrote:

The formula i have entered does not work for all conditions. Here is the
formula i have entered and works for 2 conditions but not all 4.

=IF(A12=0,"",IF(S12=0,"",IF(s12<=R12,"GREEN",IF(S1 2R12,"RED/LATE",IF(R12<=TODAY()+3,"YELLOW","WHITR")))))

A12, R12, S12 contain dates and Column T is a status column. If no date is
in column A then i want column T to be blank. And if column S date is blank,
then i want column T to be white (on target for due date, column R), or
yellow (3 days before due date). If column S is R it should be RED/LATE,
or if < should be GREEN. The red and green work fine, but i can not get the
yellow or white to work. What can i do?