Conditional Formatting text colour based on day of week

[Talldrink]

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]

Don't think that's possible with custom formatting. Can be done with VBA. Can you use a VBA solution?