Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 11th 09, 09:53 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA get ColumnName michiel.pleijte@gmail.com 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


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017