Change font color if cell color become yellow (6)

**unley** · 07-09-2009, 06:27 PM

Hi all, at the moment, I have font color white in blank cells in column E and I (from row 5 to row 245) so the visitors will not see the text.

If any of these cells become yellow (color code is 6), the font color will become black so visitors can see the text alot far better than white.

I've tried this code myself after this post but nothing happen

Please Login or Register  to view this content.

The reason why I wanted this is because the other cells in other columns has red and green color background and it's easy to see white text, but it's hard to see white text with yellow background, hope this make sense, thank you.

Test.xls

**venkat1926** · 07-09-2009, 10:05 PM

instead of change use selection change.

try this event codeand post feedback

Please Login or Register  to view this content.

By the by even if you made the font white can the user not see the value in the formula box.

**unley** · 07-09-2009, 10:30 PM

Thank you ventkat1926 for replying. It works great only when click on yellow cells to make text black.

Sometime when I highlight two or more cells at once like D19 & E19, a Runtime Error '13' on

If Target = ""

Can there be anything in code to get around this?

Thank you.

**Phil_V** · 07-10-2009, 03:51 AM

This isn't ideal, as you will still need to move to somewhere else on the sheet for the font color to be applied, but it does mean you don't have to click on the particular cell to change it's font color, and also it won't give you range errors.
I'm not sure how you would detect the Interior.Color change event, which is what you really want to be doing.

Please Login or Register  to view this content.

**unley** · 07-12-2009, 05:31 PM

Thank you Phil_V.
I've created Project Report for others where whenever they click on the red,yellow or green objects (red is bad report, yellow is ok and green is good report) the color automatically fill in the cells in the "Report" sheet to show the reports.
So I had to fill in cells with white fonts so they cannot see the percentage of the project in blank cells "Report" sheet, only for the color cells when their background changed color.
But yellow is the worse color to see white text and that's why I wanted to change white text to black in yellow cells.

Unfortunetely, your code works almost the same as venkat1926 where I have to click on yellow cells to make text black.
So thank you Phil_V & venkat1926 for replying and giving me some nice ideas, cheers.