Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting where Matrix intersects
I have a matrix (see below) and would like to format the row yellow and the
column red and where they INTERSECT orange. I am able to get the row and column formatting to work but the intersection formula will not. apple banana grapes red 34 21 - pink 20 22 - black - - 12 Assuming I pick pink/banana, the 3rd row would be yellow, the 3rd column would be red and the value in cell C3 (22) would be orange. This is what I have right now for the intersection conditional formatting "formula is" (assuming the full table is selected) =IF(AND($A1="pink",A$1="banana"),,) If only cell C3 is selected it would be =IF(AND($A3="pink",C$1="banana"),,) But it will not work. :( Thanks for your help in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting where Matrix intersects
You don't need the IF( ,,) parts.
Take that out, and you should be gold. Or blue, red, or whatever color you choose to fill with. "Rebecca_SUNY" wrote: I have a matrix (see below) and would like to format the row yellow and the column red and where they INTERSECT orange. I am able to get the row and column formatting to work but the intersection formula will not. apple banana grapes red 34 21 - pink 20 22 - black - - 12 Assuming I pick pink/banana, the 3rd row would be yellow, the 3rd column would be red and the value in cell C3 (22) would be orange. This is what I have right now for the intersection conditional formatting "formula is" (assuming the full table is selected) =IF(AND($A1="pink",A$1="banana"),,) If only cell C3 is selected it would be =IF(AND($A3="pink",C$1="banana"),,) But it will not work. :( Thanks for your help in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting where Matrix intersects
I took the IF out and it still didn't work. I had to change the order of the
conditions so that the intersection was FIRST and then the row and column formatting were second and third. Then is worked like a charm. Thanks. "~L" wrote: You don't need the IF( ,,) parts. Take that out, and you should be gold. Or blue, red, or whatever color you choose to fill with. "Rebecca_SUNY" wrote: I have a matrix (see below) and would like to format the row yellow and the column red and where they INTERSECT orange. I am able to get the row and column formatting to work but the intersection formula will not. apple banana grapes red 34 21 - pink 20 22 - black - - 12 Assuming I pick pink/banana, the 3rd row would be yellow, the 3rd column would be red and the value in cell C3 (22) would be orange. This is what I have right now for the intersection conditional formatting "formula is" (assuming the full table is selected) =IF(AND($A1="pink",A$1="banana"),,) If only cell C3 is selected it would be =IF(AND($A3="pink",C$1="banana"),,) But it will not work. :( Thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
formula to identify exact point where trendline intersects data | Excel Worksheet Functions | |||
Matrix formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |