Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Apr 6 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 at 7:28
    
C7 is 4, C8 is 2. –  Kulis Apr 6 at 7:42
    
check your calculation mode: Formulas --> Caluculation options and also try to press F9 –  simoco Apr 6 at 7:44
    
No change (calculation options = auto). –  Kulis Apr 6 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 at 8:06

1 Answer 1

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 at 8:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.