software

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: www.excelforum.com/member.php...oamp;userid=28074
View this thread: www.excelforum.com/showthread...hreadid=500354highlight the list and select format-gt;conditional formating.
Select quot;Cell Value isquot; and quot;greater than or equal toquot;
Insert these formulas in this order and apply your formats
=LARGE($A$1:$A$60,15)
=LARGE($A$1:$A$60,30)
=LARGE($A$1:$A$60,45)

The largest 15 will be the first format, the next largest 15 will be the
second format, and the final 15 will be the third format. The bottom 15 will
be the default format.

If you have a tie you might end up with more than 15 highlighted in one
group (if it is around the break).

quot;tlosgyl3quot; wrote:

gt;
gt; I have 60 numbers in a column.
gt;
gt; I would like to apply a conditional format that colours the cell
gt; background for the highest 25%, the next 25%, the next 25% and the
gt; lowest 25%.
gt;
gt; I know that only three conditional formats can be applied but the
gt; fourth would comprise those that did not meet the condtion and would be
gt; left with a white background.
gt;
gt; Help appreciated
gt;
gt; tlosgyl3
gt;
gt;
gt; --
gt; tlosgyl3
gt; ------------------------------------------------------------------------
gt; tlosgyl3's Profile: www.excelforum.com/member.php...oamp;userid=28074
gt; View this thread: www.excelforum.com/showthread...hreadid=500354
gt;
gt;


Many thanks for the help and many apologies for not replying sooner.--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: www.excelforum.com/member.php...oamp;userid=28074
View this thread: www.excelforum.com/showthread...hreadid=500354