Conditional Formating Question

[RalphSE]

Hi,

I want to setup a conditional formatting for certain columns of data that will test the previous 10 rows, i.e. if I am in cell E66, the formula will look at cells E66 thru E57, then

if E66 is the lowest of the 10 values it will highlight that cell GREEN
if E66 is the largest of the 10 values it will highlight that cell RED

is this possible?? i was trying to set it up using conditional formatting but encountered severe brain lock

thanks

Hi

Select E66 and in CF, set to 'formula is' and try:
=E66=MAX(E57:E66)
and set your green pattern - and then select the next condition and use
=E66=MIN(E57:E66)
and set your red pattern

Hope this helps.
Andy.

"RalphSE" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I want to setup a conditional formatting for certain columns of data
> that will test the previous 10 rows, i.e. if I am in cell E66, the
> formula will look at cells E66 thru E57, then
>
> if E66 is the lowest of the 10 values it will highlight that cell
> GREEN
> if E66 is the largest of the 10 values it will highlight that cell RED
>
> is this possible?? i was trying to set it up using conditional
> formatting but encountered severe brain lock
>
> thanks
>
>
> --
> RalphSE
> ------------------------------------------------------------------------
> RalphSE's Profile:
> http://www.excelforum.com/member.php...o&userid=29931
> View this thread: http://www.excelforum.com/showthread...hreadid=521768
>

[RalphSE]

works like a champ, thanks!!!!!!!!!