ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   highlighting intersecting Cells if ColumnName=Value in an other Co (https://www.excelbanter.com/excel-programming/428290-highlighting-intersecting-cells-if-columnname%3Dvalue-other-co.html)

marjattanb

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!



All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com