3 Conditional Formatting - 3rd one not working ?

**SVTF** · 06-06-2012, 11:37 PM

Here is what I have ...

I have 3 CF's in Column G:

=AI577>14 turn cell red

=AI577=0 no color

=AL577>14 turn cell red

Cell AL577 is populated but the following IF Statement:

=IF(G577="",$AK$1-E577,0)

For the purpose of testing ...

G577 is blank
AK1 has a date of 12/06/19
E577 has a date of 12/06/04
So AL577 is 15

Cell G577 is not turning red ?

The first 2 CF work ... the 3rd not so much?

Thoughts?

**npamcpp** · 06-07-2012, 12:31 AM

Assuming this is Excel 2003 or earlier (please update your profile to state your version): The order of the conditions matter. If Excel finds a condition that is TRUE, it will format the cell and not carry on with the next condition. In this case, AI577 is empty, which is the same as =0 so the fill will be set to no color and the evaluation stops.

Depending on the logic and flow in your workbook, you will need to re-order the conditions.

In Excel 2007 and later, you can choose to stop after a condition is TRUE or to carry on evaluating all conditions. This is done in a tick box in the Rules Manager.

**SVTF** · 06-07-2012, 12:34 AM

Originally Posted by npamcpp

Assuming this is Excel 2003 or earlier (please update your profile to state your version): The order of the conditions matter. If Excel finds a condition that is TRUE, it will format the cell and not carry on with the next condition. In this case, AI577 is empty, which is the same as =0 so the fill will be set to no color and the evaluation stops.

Depending on the logic and flow in your workbook, you will need to re-order the conditions.

In Excel 2007 and later, you can choose to stop after a condition is TRUE or to carry on evaluating all conditions. This is done in a tick box in the Rules Manager.

Thank You ... As to update my profile ... At work its 2003 and home its 2007.

Will give the order a try.