conditional formatting a cell that has a formula
 

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

conditional formatting a cell that has a formula
 

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

conditional formatting a cell that has a formula
 

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

conditional formatting a cell that has a formula
 

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

conditional formatting a cell that has a formula
 

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

conditional formatting a cell that has a formula
 

Hi,

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

conditional formatting a cell that has a formula
 

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