Conditional Formatting

[howard]

I have the following conditional formatting below so that if the rate in Col A <>14% and the value <> 0 in Col E, then columns A:G that are part of the CF are highlighted in Blue

 =IF(AND($A2<>14%),$E2<>0)

I need to amend my formula so that if #Div/0! is in Col A and col E <> 0 then the cells must also be highlighted


It would be appreciated if someone could kindly amend my formula to incorporate the above requirement

 

[njimack]

Maybe this (untested)...

 =IF(AND(OR($A2<>14%,ISERROR($A2)),$E2<>0)

 

[howard]

thanks for the help. I had to amend slightly as one parenthesis missing after 14%, but it does not highlight any of the cells per my requirement

 =IF(AND(OR($A2<>14%),ISERROR($A2)),$E2<>0)

Kindly test and amend when you have a chance

 

[njimack]

Harder than I expected. I think this works for all conditions...

=IFERROR(AND($A2<>14%,$E2<>0),ISERROR($A2))

 

[howard]

Thanks very much for your help. Your amended formula works perfectly for the CF