| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shading Cells
Select the rows in which you want to shade the cell with the max value, say
rows 2-10)! Use Format/Conditional formatting, fill the Format conditions box like this: Cell value equals to =MAX(2:2) Choose a color! Regards, Stefi €˛Charlie Birkett€¯ ezt Ć*rta: Should be very simple! I need to shade gray the cell that contains the highest number in a row using a formula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Automatic Shading of Cells | Excel Discussion (Misc queries) | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
