Link to home
Create AccountLog in
Avatar of Randy Downs
Randy DownsFlag for United States of America

asked on

Excel 365 Conditional Formatting

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
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Randy Downs

ASKER

Works great, thanks!