Conditional Formatting Based on a Value in Another Cell

[ernstpete]

I work for a Market Research company and there is this long formula that tests whether the difference from month to month is significantly higher or lower.

What I would like to set up is conditional formatting for the data cell in CELL B7 (45%) where the color of the cell would be determined by whether the formula in CELL P7 produces a value of either +1.64 or -1.64.

(I want to show the data in B7 but have the color determined by the value in P7.)

 

[brian.wethington]

CF

formula is

=Abs(P7) = 1.64

Format as needed.

Hope this helps!