conditional formatting a cell that has a formula

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
the conditional formatting seems to only reconise the formula and not the
answer in the cell
Please help

Regards Anthony
 
M

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

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top