condition formatting not working

[crapit]

$N29="$0.00" applies to $O29, but it didnt trigger when O29= 0
Note: format at O29 nbr cells set to currency $

 

[Bob I]

Try explaining again what is set and what should happen. Your first
attempt is too cryptic.

 

[Don Guillett]

Try $N29=0
simply use 0 zero

 

[norie]

The value in the cell only appears as $0.00 because that's how it's
formatted, the real value is 0, so that's what you use in the
conditional formatting.

 

[crapit]

N O
$0.00 -$50.00


If N = nothing, i.e no value, not even zero, then condition shouldnt have
occured