Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

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
0
cpatte7372
Asked:
cpatte7372
  • 2
1 Solution
 
barry houdiniCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now