Using day of the week to select code to run

[arleutwyler]

Hi All, I am trying to create a tracker that uses the day of the week as a variable to determine which sheet code should be run. I am trying to create a document that, for example, on Monday someone makes a change to a date the cell automatically changes color to yellow, and on Tuesday the cells that have been changed, changes color to green, and so on with different colors for each day of the week.

I have the code to automatically change a cells color when a change happens in a cell, below

Please Login or Register  to view this content.

I also have the code to determine which day of the week it is ...

Please Login or Register  to view this content.

The part I am struggling with is the fact that the color changing portion of code is sheet code and I don't know how to make it determine the day of the week (mon, tue, wed...) and then make it chose the correct color for the day.

Thank you all for all of your help in advanced!!!

Alex

[AlphaFrog]

Deleted. Double post. (Bad edit)

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

Color Palette and the 56 Excel ColorIndex Colors

[arleutwyler]

Wow... That's impressive, Thank you for work on this its perfect!