conditional formatting a cell that has a formula

  • Thread starter Thread starter Anthony96960
  • Start date Start date
A

Anthony96960

I have a list with a column (G) of answers ie (G3) =IMSUB(D3,F3) .etc
I am trying to colour code the answers ie <250 = green
250<500 = gold
500 = red
Click to expand...
the conditional formatting seems to only reconise the formula and not the
answer in the cell
Please help

Regards Anthony
 
If the formula returned "numbers" don't respond to the CF, then they probably
aren't real numbers. You could try coercing these to real numbers (within the
CF) by adding a zero: +0. like this ..

Apply these triplets in the CF's Formula Is:

Cond1: =AND(G3>0,G3+0<250)
Format > Green

Cond2: =AND(G3+0>=250,G3+0<=500)
Format > Gold

Cond3: =G3+0>500
Format > Red

Success? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
 
Thanks Max that worked a treat
The only ones that arn't coloured are the ones that equal zero, which is ok
Thanks again
 
Hi Anthony

If you want to color 0's change the 1st condition formula to

=AND(G3+0>=0,G3+0<250)

If this post helps click Yes
 
Back
Top