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?