Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
Cell Value Updated based cell input | Excel Discussion (Misc queries) | |||
How do I setup Conditional formating for a cell that has a yes or. | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |