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:

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