Highlight cell if one cell is blank and another shows zero

[SaraWitch]

Hello peeps.

I want to highlight a cell based on two others; if A1 is empty and B1 is higher than zero (0). However, B1 has a formula that returns a number and the following Conditional Formatting formula is turning all cells red (because of the formula, I believe):

=AND($B1>0,$A1="") (then set format as fill red)

I've tried it both ways, with the same result.

Any advice would be gratefully received...

Ta muchly!

 

[Fluff]

Maybe

=AND($B1<>"",$A1="")

 

[Joe4]

What is your formula in column B?
What range are you trying to apply this Conditional Formatting to?

 

[SaraWitch]

Thanks, @Fluff. That works, but I don't want the cell highlighted if the formula result is zero (0). I just want the cell highlighted if the formula returns any number over zero...

 

[Fluff]

Maybe

=AND(ISNUMBER($B1),$B1>0,$A1="")

 

[SaraWitch]

Spot on!

Thank you, as always, @Fluff! ?

 

[jtakw]

Hi,

This works also:

=AND(N(B1)>0,A1="")

 

[Fluff]

Glad we could help & thanks for the feedback.