Excel 2007 : Highlighting minimum value

[sctwin2]

I have about 200 rows with 8 columns of data. I need to find the minimum of the 8 columns for each row. How can I use a condintional formula? I used =$Y$3=MIN($Y$3,$AD$3,$AI$3,$AN$3,$AS$3,$AX$3,$BC$3,$BH$3,$BM$3). It works great for row 3 but I can't get it to work for the rest of the worksheet.

[teylyn]

Hi,

try this in Y3

=Y3=MIN($Y3,$AD3,$AI3,$AN3,$AS3,$AX3,$BC3,$BH3,$BM3)

and then copy the format to the other rows. You do not want to use absolute referencing for your tested cell, so it can adjust for the other cells in the row. For the Min() function, you only want the absolute rerference in the columns, but the rows should adjust to the current row.

hth

[sctwin2]

I've never used CF before. How do you copy the format to the other rows?

[teylyn]

select the cell, copy, select the target cells, Paste Special - tick Formats

Or

select all the cells you want to apply the conditional format to and then define a new rule with the formula as above, with all cells selected.

[sctwin2]

cannot get it to work

[teylyn]

select all the cells you want to apply the conditional format to
click Conditional Formatting on the Home ribbon
click New Rule
click Use a formula to determine ...
enter this formula into the formula field

=Y3=MIN($Y3,$AD3,$AI3,$AN3,$AS3,$AX3,$BC3,$BH3,$BM3)

click the Format button and assign the red color
click OK until you're back in the worksheet