Conditional Formatting

[vmohan1978]

Dear All,
I am preparing a compartive statement i want to highlight the max and min a
group of cells.
quote-1 quote-2 quote-3
100 150 200

like this upto quote-6
I want to highlight the number max of 6 as red and min of 6 as yellow.

Please do the needful .

 

[vmohan1978]

Dear Jacob it worked perfectly , Thank you very much.

what about when we have to select data not in a range ? example, if i have
to select c2,e2,g2,i2,k2 etc?
Please do the needful .

 

[vmohan1978]

Dear Jacob ,
I got it , first i typed only cell reference like c2,e2,g2,f2 etc it did 't
work then i used absolute reference using $ sign before cell reference, it
worked perfectly .
It saved my time lot .
Thank you very much .