Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shading Cells
Should be very simple!
I need to shade gray the cell that contains the highest number in a row using a formula |
#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 |
Reply |
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 |