Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting intersecting Cells if ColumnName=Value in an other Co
Hello, I have a table with
Col. Heads: 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 it!!) 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 help me! Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA get ColumnName | Excel Programming | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Value at Intersecting cells | Excel Programming | |||
Value at Intersecting cells | Excel Programming | |||
Value at Intersecting cells | Excel Programming |