Conditional format where value is 0 (but not for a blank cell)

[pat brown]

Hi

I have a range of columns and rows, say V3:AB50 that contain various values or are blank

I want to highlight any cell that has a value of 0

I don't want it to highlight any blank cells which the simple 'equal to 0' seems to include

Thank you

[wfm007]

if possible attached the reference file

[Fotis1991]

Try in conditional format rules.

=AND($D1<>"",$D1=0)

The example is for D1. Fix the renge according your needs.

[pat brown]

Thank you Fotis1991, that has solved it for me

[Fotis1991]

You are welcome.

Thanks for the feed back and for reb*