conditional formatting a cell that has a formula

[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

the conditional formatting seems to only reconise the formula and not the
answer in the cell
Please help

Regards Anthony

 

[Max]

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
---

 

[Max]

Errata, this line should have read:
Cond1: =AND(G3+0>0,G3+0<250)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Anthony96960]

Thanks Max that worked a treat
The only ones that arn't coloured are the ones that equal zero, which is ok
Thanks again

 

[Jacob Skaria]

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

 

[Ashish Mathur]

Hi,

As an alternative to Max's solution, you may multiply by 1 instead of adding
0.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Max]

Welcome, glad it worked out fine for you
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik