Conditional Formatting help

[MOB]

Hi

Cell B38 needs to have a red background colour if;

- cell B6 is not zero
- and cell B38 is zero or blank

How can I do this?

Thanks

 

[DominicB]

Good afternoon MOB

- cell B6 is not zero
- and cell B38 is zero or blank

Conditional formatting evaluates zero and blank as the same, so we only need to put three conditions not four (assuming that a value must be present in B6)

Formula Is
=AND(NOT(ISBLANK($B$38)),$B$38<>0,$B$38=0)

HTH

DominicB

 

[MOB]

Thanks DominicB