Thank you for your help.

We are on the right track, but now i get this



...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


what i need is this

...........Col A...ColB...Col C
Row 1 data1 data2 data3
Row 2 data1 data2 data3
Row 3 data1 data2 data3


The text color for column for a and c will not be the same for the entire coulmn.
Insted I need the text color for an entire row to match the text color in column b for each individual row.


In other words, If the text in b7 is red then the text in a7 and c7 should also be red but b9 is green so I need the text in a9 and c9 to also be green.


Thanks for any help you can give.