Conditional Formatting Excel Confusion

Hello Experts

I kinda baffled why the conditional format highlighted in Green works (please see attached spreadsheet) but the conditional format highlighted in Blue doesn't, though both formulas are the same just reference different cells.

Can someone shed some light on it?

Cheers

Carlton
EE20-Day-Low.xlsm
cpatte7372Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Hello Carlton,

Your blue formatting references a cell in row 1 but the range starts at row 2 so they are all one row out - these ought to match - see attached - I changed the formula and the range

regards, barry
EE20-barry.xlsm
0
 
cpatte7372Author Commented:
Cheerz Baz
0
 
cpatte7372Author Commented:
Thanks Bazza
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.