Is this possible with Conditional Format ?
Posted by Bruno on December 14, 2001 3:26 AM
The cells of column F contains the columns that need some extra attention of the user. I want to use cond.format to highlight these columns :
cell F2 : "HLM" means that cells H2+L2+M2 need attention
cell F3 : "GHKN" means that cells G3+H3+K3+N3 need attention
column() returns the column number (ex. 8 for column H),
when I add 64 to this number I become the ASCII code of that column (ex. H)
Which code do I have to use in the cond.format for the cells in range F2:Pxx ?
Any idea's ?