Excel 365 Conditional Formatting

Randy Downs
Randy Downs used Ask the Experts™
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
Try changing =J2 to =$J2.

Author

Commented:
Works great, thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial