CONDITIONAL FORMATTING

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

The conditional formatting function in EXCEL seems to be
working incorrectly sometimes. I am in D15 and I have
said if the cell value is greater than D16 (which is
true) then display writing in green, but if it's less
than D16 display writing in red. D15 is 86 and D16 is 75
but D15 is displayed in red instead of green.

Can someone help me?

Thanks
Dale
 
Dale,

CF works.

Show us the CF formulae that you are using, all of them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
My guess is that you have applied it incorrectly, format>conditional
formatting formula is

=$D$15>$D$16

click format and select green, click add and formula is

=$D$15<$D$16

click format and select red, click OK twice

if that doesn't work then D16 must be text
 
Dale, that should work, for conditionl formatting do you have this?
condition 1 cell valve is greater than =$D$16, and format green
condition 2 cell valve is less than =$D$16, and format red

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
This is what I have but for some reason it's not working
properly or I have done something wrong
 
D16 is a number - 75 and it's still not working
-----Original Message-----
My guess is that you have applied it incorrectly, format>conditional
formatting formula is

=$D$15>$D$16

click format and select green, click add and formula is

=$D$15<$D$16

click format and select red, click OK twice

if that doesn't work then D16 must be text

--

Regards,

Peo Sjoblom




.
Click to expand...
 
In another cell on the sheet, what do you get if you enter
=D15-D16
This will test if both are numbers and not text representations of numbers
 
Back
Top