The column references are absolute, so that all 3 cells in the row will refer to the same range.

To find the lowest value, use MIN =MIN($C2:$E2).

To find the second highest value, use LARGE =LARGE($C2:$E2,2).

To find the highest value, use MAX =MAX($C2:$E2).To find the highest, second highest, and lowest values for cells C2:E2 with a worksheet formula, you could do the following: Ron didn’t say that the three cells were adjacent, in the same row, but I made that assumption in my example, shown below. three different worksheet in the same file)

Also can this be done across worksheets (i.e. I know it can be done using cell fill but, with a large spread sheet, it will look like dog’s breakfast. I am trying conditional format a range of three cells where the FONT of the highest value in the range will be in Red follow by Blue and Green. The first question is from Ron, who wants to change the font colour, instead of the fill colour: Maybe you’ve encountered similar conditional formatting problems, and this will help. I’ll answer the questions here, so they’re easier to find. Guido wants to highlight values that aren’t multiples of another cell’s value.Ron asked about changing the font colour for the highest, second highest and lowest values.This week, there were a couple of Excel conditional formatting questions in the blog comments.

If then formula conditional formatting