Change font colors from Column A, checking Column G

**Marco-Kun** · 04-15-2009, 08:41 AM

Hello everyone.
I am a new member, with not a lot of VBA experience. Sorry for the vague title .. couldn't come up with something ^^"

The idea is, I made an list with several anime titles I am watching (in column A) In column G it shows the status; "Watching", "Completed", "Planning to Watch", "On-Hold" or "Dropped". I managed to let the colors of those words change with this code:

Please Login or Register  to view this content.

Is there a code to change the font color from the titles in column A to the same as the status in column G as soon as I change the status in column G? (I added a small example)
Thanks in advance
Marco

**StephenR** · 04-15-2009, 08:50 AM

Does this do what you want?

Please Login or Register  to view this content.

**Marco-Kun** · 04-15-2009, 08:59 AM

Originally Posted by StephenR

Does this do what you want?

Please Login or Register  to view this content.

Thanks for the fast reply ^^ With that code, it does change the color in column A, that is good. But the colors in column G doesn't change anymore. It stays the same color. I added the outcome.

**StephenR** · 04-15-2009, 09:02 AM

OK, well you need both lines:

Please Login or Register  to view this content.

**Marco-Kun** · 04-15-2009, 09:08 AM

Originally Posted by StephenR

OK, well you need both lines:

Please Login or Register  to view this content.

Thank you very much, StephenR.

That worked.
I didn't notice I needed the first line as well.
[SOLVED]

Change font colors from Column A, checking Column G

LinkBack

Thread Tools

Rate This Thread

Display

Change font colors from Column A, checking Column G

Re: Change font colors from Column A, checking Column G

Re: Change font colors from Column A, checking Column G

Re: Change font colors from Column A, checking Column G

Re: Change font colors from Column A, checking Column G

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions