Source: www.techonthenet.com

Question:

• 30 ++ change of the cell "you have marked..." color table green for good
  
• Yellow table for color agreement 15 29 change the cell "you have marked..."
  
• change of 15 or less cell "you have marked..." "color table to red for bad

How can I make a separate cell (most likely E1) to automatically change the color of the cell of the table B2 - D4 (the box "you have marked...") () based on the score in cell C2 (30) and the above data?

Here are my workbook to give you a better idea, it contains no confidential: download data from my SkyDrive

I am working on is on the sheet "Results", but the data values are read from the survey sheet.

Because the real statement side of this workbook data validation, you must download it from my SkyDrive and open in offline mode in the full MS Excel.

Answer:

I'm confused. Download your sample workbook, the lines are merged and columns step merge.

I assume that you described this evil and the downloaded workbook is correct.

The modified value in the form with a conditional formula. To do this:

Select the range B2: D4 (these cells are treated as B2: D2)

Select the Conditional Format. (Close Center Ribbon home bar)

Select new rule

Select use a formula to determine which cells to format

In the field of values where this formula is true: insert the following text:

=$ C2 > = 30

Click the Format button and select the tab required at the top of the dialog box and define the required format if the formula returns the value true.

Repeat the above, but the second formula is.

= AND($C2>15,$C2)

and the third formula as follows.

=$ C2< =="">

Just for the exercise, while the range is selected, select the conditional format once again, and then manage rules. You can change each of them, if necessary by selecting the line and click Edit. You can also adjust their order by selecting and use to the place and the arrow buttons to move to the bottom. You can also click the box stop if this is true. (This is used when more than one State may be true and you do want the other.) (This should not occur with these forms where I used and gatekeeper.)

Note: If you make an error in the entry/editng a formula, and then when you click on the field, press F2 to place otherwise edit mode when you press the arrow keys, that he will think that you want the adjacent cells, added to the formula.