format cells depending on value range


G

gashman

Using Excel 2003 and am trying to format cells depending on a range of values
e.g.

If the value is less than 50.999% then colour the cell red

If the value is between 51% and 74.999% then colour the cell orange

If the value is more than 75% then colour the cell green

I have managed to get the first and third examples to work using conditional
formatting (formula is: =B4<0.50999) but can't seem to get it to work if the
value is between two specific values.

Any help would be appreciated.
 
Ad

Advertisements

S

Stefi

Maybe

=B4<51% for red
=AND(B4>=51%,B4<75%) for orange
=B4>=75% for green


--
Regards!
Stefi



„gashman†ezt írta:
 
T

T. Valko

Try it like this...

=AND(cell_ref>lower_boundary_value,cell_ref<upper_boundary_value)

Or...

=AND(cell_ref>=lower_boundary_value,cell_ref<=upper_boundary_value)
 
J

Jim Thomlinson

CF's are evaluated in order. As soon as a conditon is met it stops evaluating
so all you need is

Less than 51%
Less than 75%
Greater than or equal to 75%
 
J

Jacob Skaria

Use the below formulas for a selected range say A1:A10 with active cell A1.


=A1<50.999%
=MEDIAN(51%,A1,74.999%)=A1
=A1>75%
 
Ad

Advertisements

J

Jacob Skaria

Ofcourse the 1st one has to be this way to handle blanks

=AND(A1<>"",A1<50.999%)
 
Ad

Advertisements


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