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

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(G30,G3+0<250)
Format Green

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

Cond3: =G3+0500
Format Red

Success? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Anthony96960" wrote:
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

Errata, this line should have read:
Cond1: =AND(G3+00,G3+0<250)
--
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

"Max" wrote:

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

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


"Anthony96960" wrote:

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

"Max" wrote:

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

Hi,

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

Welcome, glad it worked out fine for you
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Anthony96960" wrote in message
...
Thanks Max that worked a treat
The only ones that arn't coloured are the ones that equal zero, which is
ok
Thanks again