• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 109
  • Last Modified:

Conditional Formatting Issue

I must be missing something - I've pretty simple conditional formatting on the attached sheet. Columns 1, 2, and 3 should be completely independent of column 4, but any value greater than 3 in column 4 affects the formatting of column 3. What am I missing?

Test-25Mar15-0900.xlsx
0
Michael Vasilevsky
Asked:
Michael Vasilevsky
  • 3
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I don't understand what you are trying to do.

Your conditional formatting functions are for cells A2:D5, but your numbers are in row 1.
0
 
Michael VasilevskySolutions ArchitectAuthor Commented:
Those are column headers. Enter the value 3 in cell D2 and you'll see D2:D5 are formatted red. That is the correct functionality. Change that 3 to 4 however, and C2:D5 is formatted red, when only D2:D5 should be formatted red.

Hope that clarifies?
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Got it! You are missing a $ before sum($b$2:b$5)
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
There should be a $ before b$5
0
 
Michael VasilevskySolutions ArchitectAuthor Commented:
That's it! Thanks
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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