Easy Conditional Formatting (I think) Office 2007

[davejago]

Simple enough in theory. I have a table, 3 columns. Numerator, denominator, and (numerator/denominator). If the (numerator/denominator) column is between 0-30 then I want to shade columns 1 & 2 red, if it's 30-60 green, if it's 60-100 blue.

Simple, right?!

I've never done this type of conditional formatting where you format a cell based on another cells contents. Is this possible?

I am using Office 2007.

 

[Datsmart]

Check out this demo page:
http://www.datapigtechnologies.com/flashfiles/conditionalformatexcel.html

 

[davejago]

Helpful but it doesn't answer my question. I need columns/cells to be formatted based on the results of another cell. So columns A & B to be shaded based on the calculation in column C.

 

[RoryA]

1. Select columns 1 and 2.
2. Select Conditional Formatting-Manage Rules.
3. Click New Rule.., select 'Use a formula to determine which cells to format'
4. Enter =$C1<30 and select your format.
5. Repeat steps 3 and 4 using the formulas =$C1<60 and =$C1<=100 and choosing the formats required.
6. Make sure the formulas are in the right order (so that the check for less than 30 is above the check for less than 60 and so on) and that they all have 'Stop if true' checked.
HTH