Conditional Formatting
 

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 .

Conditional Formatting
 

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 .

Conditional Formatting
 

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 .




"Jacob Skaria" wrote:

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 .

Conditional Formatting
 

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 .


"vmohan1978" wrote:

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 .




"Jacob Skaria" wrote:

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 .