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
|