Change Color Of Text First Time It Appears In A Range

**ZooTV92** · 10-23-2011, 04:27 AM

There will be 18 rows, and 18 columns. I would like to be able to change the color of the text the first time it appears in a particular range to red.

Example:

A A A B B A C A C

The first A , the first B, and the first instance of C would appear red.

I'm not going to bother asking if this is possible. I'm sure if I asked if I could get some code to launch the space shuttle from my desktop, I would have the code in a couple of hours. This board is amazing....

Thanks in advance....

**martindwilson** · 10-23-2011, 05:16 AM

range = what? row 1? column 1? any where in the 18?X18 grid?

**ZooTV92** · 10-23-2011, 05:42 AM

I mis-spoke when I said 18 columns. There will be 7 columns, one for each day of the week.

I would be looking across rows for the first instance of text. The first row starts at B2 and ending with the last row at B19

And if it matters, which it probably does, there will be instances of multiple words in each cell, so I need to be able to isolate the first time each word pops up across the row, even if it's mixed in with other words....so, it could look like:

B2 - A
C2 - A B
D2 - A B
E2 - A
F2 - C
G2 - B
H2 - A D

Colored red would be A (B2), B (C2), C (F2), D (H2)

The grid would be B2:H19

Thanks!

**martindwilson** · 10-23-2011, 07:23 AM

cant see how it can be done with mixed characters/words in the same cell maybe possible with vba but will it simply be single characters as you have suggested? you cant use functions to format individual characters in a string

**ZooTV92** · 10-24-2011, 01:33 PM

Thank you.

Then let me revise this since I really need this to work in some form. Would it work if I "simply" had one word in each row?

B2 - A
C2 - B
D2 - B
E2 - A
F2 - C
G2 - B
H2 - D

colored red:
A (B2), B (C2), C (F2), D (H2)

There will be words, not letters. I am using letters for simplicity. Thanks again for taking the time to respond.