C crapit Sep 1, 2009 #1 $N29="$0.00" applies to $O29, but it didnt trigger when O29= 0 Note: format at O29 nbr cells set to currency $
$N29="$0.00" applies to $O29, but it didnt trigger when O29= 0 Note: format at O29 nbr cells set to currency $
B Bob I Sep 1, 2009 #2 Try explaining again what is set and what should happen. Your first attempt is too cryptic.
N norie Sep 1, 2009 #4 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.
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.
C crapit Sep 4, 2009 #5 N O $0.00 -$50.00 If N = nothing, i.e no value, not even zero, then condition shouldnt have occured
