Activate data according to the value key in in other cell.
Hi
I need to activate data according to the value key in in other cell.
eg:
If Then
A 1 2
B 1 3
C 2 3
D 1 2 3
if the value is A then 1 and 2 should be highlighted
and if B then 1 and 3,
if C then 2 and 3
and if D then 1,2 and 3 should be highlighted or viewed
|