We help IT Professionals succeed at work.

Excel 365 Conditional Formatting

Randy Downs
Randy Downs asked
I have a spread sheet with data in cells (C:H) of each row.  Minimum & Maximum are in columns I, J respectively.

I want to highlight the cell that matches the Max - column J.

Matching J2 seems to work when the Max is in column C but doesn't match anything when the Max is in column D:H.

What am I doing wrong?

The formula I have is
applies to =$C$2:$H$214

Open in new window

Data Columns C-H
Min Column I
Max Column J
Range - $C$2:$H$214
Watch Question

Analyst Assistant
Try changing =J2 to =$J2.


Works great, thanks!