Conditional formatting changing color even on blank value

[ajayanand1717]

I have tried to put conditional formatting in a range which is blank that cells that contain value equal to 0 should be changed to green color but when i apply this to the range the whole range changes color to green , why it is happening with blank cells , cells with 0 value should have green color can anybody explain this to me

HYPERLINKS.xlsx
	M
14
15
16
17
18
19
20
21
SAVING KHATA

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M14:M21	Cell Value	=0	text	NO

Thanks
ajay

 

[Peter_SSs]

Try "Use a formula to determine which cells to format" and use
=EXACT(M14,0)

 

[ajayanand1717]

Try "Use a formula to determine which cells to format" and use
=EXACT(M14,0)

Yeah it works perfectly but i am still amazed at why my condition was not working how can a blank cell change color without entering the 0 value. anyway thanks for your help

 

[Peter_SSs]

anyway thanks for your help

You are welcome.

i am still amazed at why my condition was not working how can a blank cell change color without entering the 0 value.

There are many instances where Excel treats a blank cell as zero. Here are a few

Book1
	A	B	C	D
1		6	0	#DIV/0!
Sheet1

Cell Formulas
Range	Formula
B1	B1	=6+A1
C1	C1	=6*A1
D1	D1	=6/A1