Changing cell colors based on day of the week

wjoyner · Feb 18th, 2002, 02:37 PM

I would like to set a range of cells to a particular color based on the day of the week. For example: Monday would be blue, Tuesday, yellow, etc. Additionally, I would for the worksheet to figure our what day of the week it is based on a 02/18/02 date entry format. So today for example, it being - 02/18/02 (Monday) would set cells A1:A5 to a Light Blue background with black font. This is probably easy for some of you, but doing this manually is a real pain. I appreciate any help you can offer. Thanks! Nice Board!

Jack in the UK · Feb 18th, 2002, 02:46 PM

Hi

In function see Conditioal formatting or post in VBA section as no limit to conditional formats if programmed correctly

I have a script simple it is and i use on command button 25 conditioans as you ask

HTH
Rdgs
==========
Jack

Jack in the UK · Feb 18th, 2002, 02:47 PM

Hi

In function see Conditioal formatting or post in VBA section as no limit to conditional formats if programmed correctly

I have a script simple it is and i use on command button 25 conditioans as you ask

HTH
Rdgs
==========
Jack

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 02:37 PM	#1
wjoyner New Member Join Date: Feb 2002 Location: Wayne Joyner - Omaha, NE Posts: 9	I would like to set a range of cells to a particular color based on the day of the week. For example: Monday would be blue, Tuesday, yellow, etc. Additionally, I would for the worksheet to figure our what day of the week it is based on a 02/18/02 date entry format. So today for example, it being - 02/18/02 (Monday) would set cells A1:A5 to a Light Blue background with black font. This is probably easy for some of you, but doing this manually is a real pain. I appreciate any help you can offer. Thanks! Nice Board!

Feb 18th, 2002, 02:46 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi In function see Conditioal formatting or post in VBA section as no limit to conditional formats if programmed correctly I have a script simple it is and i use on command button 25 conditioans as you ask HTH Rdgs ========== Jack

Feb 18th, 2002, 02:47 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi In function see Conditioal formatting or post in VBA section as no limit to conditional formats if programmed correctly I have a script simple it is and i use on command button 25 conditioans as you ask HTH Rdgs ========== Jack