Conditional formatting coloring cells not meeting criteria

[mystie]

Hello everybody!

I have a spreadsheet with several columns containing numerical data. I'd like to color the cell with the largest value in each column. I have set up conditional formatting using the following formula

=AND(C8=MAX(C8:C47),C8<>"")

This formula applies to range =$C$8:$R$47.

However, the formatting doesn't work correctly. In some columns it colors cells which don't meet the criteria.

For example, in one column, the cells containing the values 73, 72, 70, 67 were colored, when the largest value is 73.
In another column where the largest value is 83, it colored the cells with values 83, 74, 67.

Any help on how to make the formatting work?

 

[BrianJN1]

Do you have other conditional formatting rules in your workbook?
Is it possible that some of those are within the range that you have designated?

Go to manage rules and choose "This worksheet" from the drop-menu.
Does that bring up ranges and rules applicable to your specified range?

 

[mystie]

I've found the mistake. I've edited the rule as follows:

=AND(C8=MAX(C$8:C$47),C8<>"")

and now it works.

Though the columns change, the rows should not.

Brian, thanks for your input.

 

[BrianJN1]

Fine. Glad you have solved the issue.