|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
highlighting intersecting Cells if ColumnName=Value in an other Co
Hello, I have a table with
AA AB AC AD EA EB EC 3 columns for the "if-conditions"
Values A B B+ D AB AC EB
A C E F AA EA EC
B A E E AC AD EB
(I hope the table does not get completely out of given format when I post
I would like to highlight the intersecting cells: Highlight intersecting
cell (whether there is a value or not) if Col. head=any of the 3 values in
the corresponding row's "condition colums".
So on the first value-row cells containing B,B+and D would be hihglighted,
on 2nd value-row the empty cell in column AA, the one containing E and F
would be highlighted etc.
On every row thus 3 cells would be highlighted, at the intersections of any
of the three values in condition cells on that row and the Columnheads.
And the representation meeding this is tomorrow
I wonder if I could make my problem clear - and if anyone would be able to
Thanks in advance!
|Thread||Thread Starter||Forum||Replies||Last Post|
|VBA get ColumnName||[email protected]||Excel Programming||2||January 20th 07 12:22 AM|
|Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck.||Jamie Furlong||Excel Discussion (Misc queries)||6||August 28th 05 09:27 PM|
|Value at Intersecting cells||Wild Bill[_2_]||Excel Programming||0||August 28th 03 04:29 AM|
|Value at Intersecting cells||Leo Heuser[_2_]||Excel Programming||0||August 27th 03 02:09 PM|
|Value at Intersecting cells||Chip Pearson||Excel Programming||0||August 27th 03 02:00 PM|