|
Formula for multiple conditions
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? |
| All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com