Combination of functions for a conditional format and an array

[bdolph]

I am trying to set up a function that will do a conditional format a
cell, let's say C3 in column C based on the following

Match a column, say column C with a series of other columns D-F, by
looking at the text in C2, then scan through columns D-F to find a
unique match in the row 2 cells in these columns D-F. Once the unique
row has been found (in this case it would be E) then shade the original
cell C3 if E3 has a character in it (can be 1,2,or 3). Be able to copy
this conditional format formula to all the other cells in column C. If
done correctly I would end up having all the cells in column C shaded
in the same cells as the cells that have characters in them in column
E.

If have done some similar things with CountIF and SumIF but can't get
started on this combination. Any suggestions greatly appreciated. I
am still learning to work with arrays.




C D E F
1 Jim
2 I ST I SS
3
4 1 3
5 X 2
5 3
6 X
7 2
8 X
9
10


Thanks,

Bobby D

 

[Biff]

Hi!

You got a reply to your earlier post in .misc. Did that
not work? You should stay in the same thread.

Biff

 

[bdolph]

MIsc ?? Can't find the thread.
Bob