If Formula total is Zero Turn it Red

[rayscar]

For,
=COUNTIF(Schedule!D886,"*IV 1230*")

If the result of this formula is ZERO, then I want to make the "0" turn red
so it stands out on the worksheet. How can I do this.

Ray

 

[Dave Peterson]

Try Format|conditional formatting.

You can use:

cell value is equal to 0

 

[rayscar]

Excellent! Thanks.

Try Format|conditional formatting.

You can use:

cell value is equal to 0