Change cell color based on value in cell
 

I have a table with avrious values 1 -100. I'd like to highlight the cells
with values from 75-100 in green, 50-75 in blue, 25-50 in purple and 0 - 25
in red. How would I do this without sorting the tables?

Change cell color based on value in cell
 

Hi

Use conditional formatting. A very recent example was put he
http://www.microsoft.com/communities...r=US&sloc=&p=1


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"finomad" wrote:

I have a table with avrious values 1 -100. I'd like to highlight the cells
with values from 75-100 in green, 50-75 in blue, 25-50 in purple and 0 - 25
in red. How would I do this without sorting the tables?

Change cell color based on value in cell
 

Finomad
One other suggestion for you from personal experience:

Reading your list you have said that 0-25 is red and 25-50 is purple etc.

What colour should 25 be?

'Proper' answer
- When you do your conditional formatting you will have to choose either
0-25, 26-50, etc OR 0-24, 25-49 etc (or some other combination that wsuits
you).
- You should consider how many decimal places your data can have. Are you
really saying 0-24.999999999999999 (or 0-25 and 25.000000000000000000001 - 50)
- As you have 4 colours then one will be default. Excel will then process
the others in order. If you set up the rules in the correct order then you
could have 0-25 and 25-50, but you would still have to think carefully and
put them in in the right order.

I'd recommend doing a very quick test spreadsheet for yourself where you
enter some numbers (say 0, 10, 25, 40, 50, 50.5, 60, 75, 90, 100, 100.5, 102,
-26) and then enter your conditional formatting and see what works

M-A

"Wigi" wrote:

Hi

Use conditional formatting. A very recent example was put he
http://www.microsoft.com/communities...r=US&sloc=&p=1


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"finomad" wrote:

I have a table with avrious values 1 -100. I'd like to highlight the cells
with values from 75-100 in green, 50-75 in blue, 25-50 in purple and 0 - 25
in red. How would I do this without sorting the tables?