Conditional Formatting text colour based on day of week

Talldrink

New Member
Joined
May 20, 2016
Messages
3
Hi there,

I'm wondering if there's a way that I can format the text of a sheet so that it will automatically have a specific color relating to the day of the week the text is entered?

For example, if I enter the text on a Monday it will be green, if I enter it on Tuesday it will be red, etc.

I would also like the text to remain the color that it is originally entered in i.e. I don't want green text to turn red on Tuesday.

Is this possible?

Thanks a bunch!
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,691
Don't think that's possible with custom formatting. Can be done with VBA. Can you use a VBA solution?
 

Forum statistics

Threads
1,085,863
Messages
5,386,395
Members
401,997
Latest member
cizwiz

Some videos you may like

This Week's Hot Topics

Top