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?
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"