We help IT Professionals succeed at work.

Excel 365 Conditional Formatting

Randy Downs
Randy Downs asked
on
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
=J2 
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
Comment
Watch Question

Analyst Assistant
Commented:
Try changing =J2 to =$J2.

Author

Commented:
Works great, thanks!