Need 0 to highlight red with con.format

[ukphoenix]

Its Mr Stupid kicking in again im afraid,

I just cant put my finger on it. I need a cell to highlight RED (via conditional formating) if the cell reads 0.

When using conditional formatting and entering, the cell is equal to 0, it turns all the cells red that are empty aswell. This is what i dont what.

The only cell i require to turn RED is that with a 0 (zero) in

[Jericho]

I'm rather new to this whole Excel experience and I'm sure there's a better way to do this but here's a method I used to get around this situation:

In the conditional formating change the "cell value" drop down to "specific text" and then in the next drop down box select "beginning with" then put 0 in the 3rd box. That should do the trick, or at least be a quick fix until a better solution comes along.

[ukphoenix]

Thanx for the effort Jericho but I must be using an older version as "Specific Text" is not an option under conditional formatting. I have only "Cell Value Is" or "Formula Is"

[Portuga]

Try in "formula is": (ajust your range as you need).

(if cell value equals 0)

=A1=0

If cell value contains 0 inside a text string

=countif(A1;"*0*")

[ukphoenix]

Nope it still picks up an empty cell as a 0 (zero)

If anyone wants to try and sort it out the sheets are contained in the sample file attached.

(Sorry about the macro but this needs to stay)

[Portuga]

One workaround

Add as a first condition:
=a1="" and choose "white"

and in the second condition:
=a1=0