Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the format of data in a cell
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the format of data in a cell
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the format of data in a cell
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) -- If this helps, please click the Yes button Cheers, Shane Devenshire "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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the format of data in a cell
Hi Shane, quite correct, except that he want the maximum to show only in the
relevant column, h4ence the IF statement -- Hth Kassie Kasselman Change xxx to hotmail "Shane Devenshire" wrote: 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) -- If this helps, please click the Yes button Cheers, Shane Devenshire "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
How do you keep the data table format from changing | Charts and Charting in Excel | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Changing data format | Excel Discussion (Misc queries) | |||
Changing the format of a block of data | Excel Discussion (Misc queries) |