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