grey out certain days automatically

[labibliobecca]

Hello!

I am a newbie at Excel, but have been making task managers for my department at work. The task manager details opening and closing tasks, with boxes to initial or check off each day. The thing is, certain tasks only apply once a week, or every day except Saturday, etc. Each month I have to manually make a copy and grey out individual/merged cells to mark when a task is not applicable that day. It gets tedious, and other colleagues are nervous about messing it up if I am out.

I am hoping there is some way to make Excel know what day of the week a cell is "in," maybe using the TODAY feature? Or conditional formatting? I have watched a variety of video tutorials but have not found the solution yet. One last note: I also usually use the online version of Excel, so that multiple people can have it open simultaneously.

 

[LegendaryAxe]

You can try something like this. The weekday function (when you don't use its second argument, which I didn't in this case) will always return the number of the day of the week it's being given. Sunday is 1, Monday is 2, Tuesday is 3, etc.

Book2
	A	B	C	D	E	F
1		1	2	3	4	5
2	Process 1
3	Monday Task
4	Tuesday Task
5	Saturday Task
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:F5	Expression	=WEEKDAY(TODAY())=7	text	NO
A4:F4	Expression	=WEEKDAY(TODAY())=3	text	NO
A3:F3	Expression	=WEEKDAY(TODAY())=2	text	NO

 

[LegendaryAxe]

Or something like this:

Book2
	A	B	C	D	E	F
1		1	2	3	4	5
2	Process 1
3	Monday-Only Task
4	Tuesday-Only Task
5	Saturday-Only Task
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:F5	Expression	=NOT(WEEKDAY(TODAY())=7)	text	NO
A4:F4	Expression	=NOT(WEEKDAY(TODAY())=3)	text	NO
A3:F3	Expression	=NOT(WEEKDAY(TODAY())=2)	text	NO