Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi I want use conditional formatting. On this values:

enter image description here

everything works, but when i change values (mid and max values are similiar) to:

enter image description here

conditional Formatting do not works. What I do bad?

share|improve this question

migrated from Apr 6 '14 at 10:40

This question came from our site for professional and enthusiast programmers.

what is the values of C8 and C7? – simoco Apr 6 '14 at 7:28
C7 is 4, C8 is 2. – Kulis Apr 6 '14 at 7:42
check your calculation mode: Formulas --> Caluculation options and also try to press F9 – simoco Apr 6 '14 at 7:44
No change (calculation options = auto). – Kulis Apr 6 '14 at 7:53
I find what is wrong - C7 & C9 not contain value. They contain equation, like that "=B10". Is there a possibility to make it work? – Kulis Apr 6 '14 at 8:06
up vote 2 down vote accepted

Make sure that the referenced cell contains valid numbers.

To check this, put the formula =Mechanic!$C$8 in a blank cell. I.e., make sure C8 in worksheet named Mechanic contains 2 and C7 contains 4.

If they do contain the correct values then make sure they are formatted as number and not text. If these two are taken care of you should be good to go.

share|improve this answer
These cells contained string. When I multiplied cells by 1, conditional formatting works. Thanks! – Kulis Apr 6 '14 at 8:20

You must log in to answer this question.