Override all other conditions

[steveo0707]

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","")))))

 

[Skybluekid]

Hi
Look at the video on Condtional Formatting

 

[steveo0707]

Hi
Look at the video on Condtional Formatting

Its not a conditional formatting issue. I need to change the formula to allow when a out date is entered it can override when there is a rej. date entered.

 

[Skybluekid]

Which column is the Rej Date and which column is Date Out Column as it is not clear from the above.

 

[steveo0707]

Which column is the Rej Date and which column is Date Out Column as it is not clear from the above.

Sorry I forgot to include that in the Snapshot.

Rej. Date is Column L and Date Out is Column Q