IF Greater than for 2nd cell

[books4cars]

I have 2 columns and I want to make the text in A1 print (on paper) blank if the value of B1 is 0. How is this done? Condt'l formatting seems likr the right way, but I can't figure it out.
Thx

 

[anandvarma]

try this

Excel Workbook
	A	B
1	ad	2
2	dv	25
3
4	gr	2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =$B1=0	Abc
B1	1. / Formula is =$B1=0	Abc
A2	1. / Formula is =$B1=0	Abc
B2	1. / Formula is =$B1=0	Abc
A3	1. / Formula is =$B1=0	Abc
B3	1. / Formula is =$B1=0	Abc
A4	1. / Formula is =$B1=0	Abc
B4	1. / Formula is =$B1=0	Abc

in the custom number formatting put ;;;

 

[books4cars]

I don't understand. I'm in Excel 2010. Where do I type that?

 

[anandvarma]

FIRST SELECT THE WHOLE RANGE
IN THE CONDITIONAL FORMULA PUT THE FOLLOWING

=$B1=0

IN THE FORMAT GO THE NUMBER MENU AND SELECT THE CUSTOM NUMBER FORMATTING AND PUT ;;;

PRESS ok