1. Select the cell/Range (say A2:F2). Please note that the cell reference A2
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=A2=MAX($A$2:$F$2)
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

For Condition2 replace MAX() with MIN()

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.

--
Jacob (MVP - Excel)


"vmohan1978" wrote:

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 .