Conditional formatting doesn't want to cooperate
I don't know what you are trying to do with your formula, but what you are
actually doing is firstly testing to see whether D7/C7 is greater than -0.1.
This will return either TRUE or FALSE. You are then testing whether the
TRUE or FALSE is less than zero. Neither of them is less than zero, so the
complete formula will always return FALSE, and hence you won't satisfy your
conditional formatting test.
--
David Biddulph
"Pierre" wrote in message
...
C7 is 38,211
D7 is -2,109
D7 is conditionally formatted as follows:
Formula is: =(D7/C7(-0.1)<0)
(It should turn yellow. It doesn't)
Am I missing an operator of sorts before the last <0?
TIA for ideas.
Pierre
|