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. |
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 |