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

 

[Guest]

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]

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