I have 60 numbers in a column.

I would like to apply a conditional format that colours the cell
background for the highest 25%, the next 25%, the next 25% and the
lowest 25%.

I know that only three conditional formats can be applied but the
fourth would comprise those that did not meet the condtion and would be
left with a white background.

Help appreciated

tlosgyl3


--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074
View this thread: http://www.excelforum.com/showthread...hreadid=500354