Conditional Formatting A Cell Based on Another Cell's Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

evanjdavies@mac.com - 17 Nov 2007 17:06 GMT

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?

Reply to this Message

Bob Phillips - 17 Nov 2007 17:25 GMT

Just use a formula like

=$M2<.85

and

=$M2>=.85

Signature

---
HTH

Bob

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

>I have a report where I want to use conditional formatting on the two
> far right-hand columns.
[quoted text clipped - 11 lines]
>
> Is there a way to do this?

Reply to this Message