ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shading Cells (https://www.excelbanter.com/excel-discussion-misc-queries/63480-shading-cells.html)

Charlie Birkett

Shading Cells
 
Should be very simple!
I need to shade gray the cell that contains the highest number in a row
using a formula

Stefi

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



All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com