Conditional formatting - adjacent cells

[immm]

Hello,

I have another question for using excel for a market research application. It seems very easy but I have not being able to write the formulas in the correct format to solve it or to find an answer in the forum.

I need to apply several conditional formatting rules to column E so that I can quickly identify to which degree each element is relevant for respondents. And, then apply the same conditional formatting look of column E to several adjacent columns (A-D). But, I cannot make it work for three of the rules (somewhat good, good and somewhat bad). See the rules and formulas below:

EXCELLENT: 80% or more (Format values where this formula is true: =$E2>=0.8)

SOMEWHAT GOOD: 60% or higher, but less than 80% (Format values where this formula is true: =?)

GOOD: 40% or higher, but less than 60% (Format values where this formula is true: =?)

SOMEWHAT BAD: 20% or higher, but less than 40% (Format values where this formula is true: =?)

BAD: Less than 20% - (Format values where this formula is true: =$E2<0.2)

I'm sharing the file link below. I have many cells to format and this will be a great help.

https://www.dropbox.com/s/ed7vubpljqjuq3t/Color coding example for Chandoo.xls

Many Thanks!

 

[NARAYANK991]

Hi ,

The rules have to be in sequential order with the top-most one >=0.8 , the next lower one >=0.6 , the next lower one >=0.4 , and so on.

See this file.

Narayan

 

[immm]

Yeah! Thank you so much!!! It works perfectly.