G Guest Jan 6, 2006 #1 Should be very simple! I need to shade gray the cell that contains the highest number in a row using a formula
Should be very simple! I need to shade gray the cell that contains the highest number in a row using a formula
G Guest Jan 6, 2006 #2 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:
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:
