Changing the format of data in a cell

[dmdhca]

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

 

[Kassie]

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

 

[Shane Devenshire]

Hi,

I'm sure I'm not following something here. To get the max of row 2, use
=MAX(C$2:G$2).

Now since you are going to use conditional formatting just copy the above
formula across the row C3:G3.

To conditionally format your cell(s):

In 2003:
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=C2=C3
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
6a. Choose the Font tab and select Bold
7. Click OK once
8. Click Add and in the first box of the 2nd condition choose Formula is
9. In the second box enter the formula
=C2<>C3
10. Click the Format button and on the Font tab set the font color to white
or the same as your default background.


In 2007 you can use the same approach or a more sophisticated one:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=C2=C3
5. Click the Format button and choose a format.
6. Click OK twice
7. Click Conditional Formatting, New Rule
8. Choose Use a formula to determine which cell to format
9. In the Format values where this formula is true enter the following
formula:
=C2<>C3
10. Click the Format button and choose the Numbers tab.
11. Select the Custom category and enter ;;; on the type line (3 semi-colons)

 

[Kassie]

Hi Shane, quite correct, except that he want the maximum to show only in the
relevant column, h4ence the IF statement