C
crapit
$N29="$0.00" applies to $O29, but it didnt trigger when O29= 0
Note: format at O29 nbr cells set to currency $
Note: format at O29 nbr cells set to currency $
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
Try explaining again what is set and what should happen. Your first
attempt is too cryptic.
attempt is too cryptic.
D
Don Guillett
Try $N29=0
simply use 0 zero
simply use 0 zero
N
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.
formatted, the real value is 0, so that's what you use in the
conditional formatting.
C
crapit
N O
$0.00 -$50.00
If N = nothing, i.e no value, not even zero, then condition shouldnt have
occured
$0.00 -$50.00
If N = nothing, i.e no value, not even zero, then condition shouldnt have
occured