steveo0707
Board Regular
- Joined
- Mar 4, 2013
- Messages
- 85
- Office Version
- 365
- 2019
- Platform
- Windows
Hello,
I have a formula with multiple conditions, allowing cells in Column A(Current Status) to change different colors when certain cells are filled in. I have a Rej. Date column and a Date Out Column. I need the Current Status column to change Green when the Date out is filled in. If the Rej. Date is filled in, Current Status stays yellow even if Date out is entered. I need to know how to modify the formula below to override the Rej. Date Conditon when Date out is entered.
Formula in the column A cells is as follows:
=IF(H24="","",IF(L24>0,"F",IF(Q24>0,"C",IF(AND(D24>0,D24<H$1),"P",IF(H24>5,"L","")))))
I have a formula with multiple conditions, allowing cells in Column A(Current Status) to change different colors when certain cells are filled in. I have a Rej. Date column and a Date Out Column. I need the Current Status column to change Green when the Date out is filled in. If the Rej. Date is filled in, Current Status stays yellow even if Date out is entered. I need to know how to modify the formula below to override the Rej. Date Conditon when Date out is entered.
Formula in the column A cells is as follows:
=IF(H24="","",IF(L24>0,"F",IF(Q24>0,"C",IF(AND(D24>0,D24<H$1),"P",IF(H24>5,"L","")))))