Conditional Formating for a cell based on another cell's value
 

Hi all:

I was wondering if there was a way to put a conditional formating on a cell
based on the values of another cell. What I mean is that, if Cell A is 5 ,
make cell b Blue, not just cell A. Likewise, if Cell A is <5, make both cell
a and b red.

On the same topic, is it possible to put more than 3 conditions on a
conditional formating?

Thanks,

Steve o

This might point you in the right direction. Sometimes you need a row
formatted according to the item in A1. Use a formula in the conditional
formatting in type in something like this...

=$A1<5

This will apply the conditional formatting to the whole row based on if the
cell in column A is less than 5. The formula seems to base it off the top
left cell you have highlighted. So if you highlight B2:D5 and want the same
effect, your formula would be this...

=$B2<5

But if you want B:D to have conditional formatting while A stays the same
you can highlight B2:D5 and type this as your formula...

=$A1<5

To answer your other question, I don't believe you can have more than three,
and I don't have any workarounds for you.

"steve-o" wrote:

Hi all:

I was wondering if there was a way to put a conditional formating on a cell
based on the values of another cell. What I mean is that, if Cell A is 5 ,
make cell b Blue, not just cell A. Likewise, if Cell A is <5, make both cell
a and b red.

On the same topic, is it possible to put more than 3 conditions on a
conditional formating?

Thanks,

Steve o