Enter the following formula in C3, then copy across to G3.
=IF(C2=MAX($C$2:$G$2),MAX($C$2:$G$2),"") Select C3:G3, and set as Bold. Now
set conditional formatting - depending on which Excel you have! - to
highlight the cell with a value. In 2007, choose Conditional formatting,
create new rule, 2 colour format, set lowest value fill colour as white, and
highest value cell fill as the colour of your choice
--
Hth
Kassie Kasselman
Change xxx to hotmail
"dmdhca" wrote:
[Quoted Text] > I would like to compare a range of data on a row (C2,D2,E2,F2,AND G2). the
> highest number in that range I would like to display that number in the
> specific column on the row listed below This number must be highlighed with a
> specif color and Bold. This result number would be display under the column
> of which ever number is the highest. Example
>
> ROW C2 D2 E2 F2 G2
>
> DATA 1 3 4 7 8
>
> RESULT RUN 1 8
> (Highlighted and Bold)
>
>
> ROW C2 D2 E2 F2
> G2
>
> DATA 6 3 5 2
> 1
>
> RESULT RUN 2 6 (Highlighted and bold)
>
>
>
> Data changes weekly and the highest value would change
>
|