Forum Discussion
Conditional Formatting
In a column of numbers that contains a formula (=IF(I90>0,(SUM(H90:I90))," ") can I automatically highlight the cell which gives the highest value?
2 Replies
Select the column with the values whose maximum you want to determine. Go to home>Conditional formatting>New Rule>Select "Use a formular to determine which cells to format". Put he formular in this format as it applies to your data as shown below. Then selct "OK"
Let's say you have formulas like that in K2:K100. Select this range
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
In the box next to it, enter the formula=MAX($K$2:$K$100)
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
