On Nov 4, 3:05*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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- Hide quoted text -

- Show quoted text -

Thanks for both replies:

Lets try from scratch:
B7 is 40,320
C7 is 38,211
D7 is (2,109)
Looking to shade D7 if it's value is between zero and "up to a minus
10% difference" between the values in B and C.
We started with
=(D7/C7(-0.1)<0)

Thanks again for ideas, and education.


Pierre