Conditional Formatting A Cell Based on Another Cell's Value

[evanjdavies]

I have a report where I want to use conditional formatting on the two
far right-hand columns.

Applying conditional formatting to right-hand column 1 (RHC1) which
consists of percentages is easy. If the value in any cell in this
column is less than .85 the cell is shaded green, if greater than or
equal to .85 and less than or equal to 1 the cell is cell is shaded
yellow, if it's greater than 1 it is shaded red.

Right-hand column 2 (RHC2) consists of whole numbers. I want the
shading of the cells in RHC2 to match the shading of the cells next to
them in RHC1. I have tried to create formulas in the conditional
formatting dialog box to do this, but have had no success.

Is there a way to do this?

 

[Bob Phillips]

Just use a formula like

=$M2<.85

and

=$M2>=.85

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)