Hi

Is there another way of putting conditional formatting on a worksheet
without using the 'Conditional Formatting' function.

I need to do conditional formatting to 5 or 6 levels however I am
limited by the conditional formatting function only allowing 3 e.g.

cell value is between 1 & 50 cell turns blue
cell value is between 51 & 100 cell turns green
cell value is between 101 & 250 cell turns yellow
cell value is between 251 & 500 cell turns orange
cell value is between 501 & 1000 cell turns magenta
cell value is between 1000 & 2500 cell turns Red

Currently i can only apply the first three rules...

...any ideas???

Thanks

Dave


--
GoldDave
------------------------------------------------------------------------
GoldDave's Profile: http://www.excelforum.com/member.php...o&userid=27750
View this thread: http://www.excelforum.com/showthread...hreadid=472580