conditional formatting questions

[zakasnak]

I have a spreadsheet (duh!) that uses dates for nominations of natgas. On Monday, I nom for Wednesday (highlighted), on Tuesday, I nom for Thursday (highlighted), etc. The problem comes when today's date is a Thursday, I want the conditional formatting to highlight Saturday, Sunday, AND Monday and then on Friday, highlight Tuesday.

Tue 1/16/2018
Wed 1/17/2018
Thu 1/18/2018
Fri 1/19/2018
Sat 1/20/2018
Sun 1/21/2018
Mon 1/22/2018

Conditional Format Formulas:

Cell Value = TODAY()

Cell Value = TODAY()+2

​Help?

 

[dfsobral]

for the second condition try

cell value = IF(WEEKDAY(TODAY())=6,TODAY()+4,IF(WEEKDAY(TODAY())=5,OR(TODAY()+2,TODAY()+3,TODAY()+4),TODAY()+2))

 

[zakasnak]

It highlighted all of the days except for TODAY()....

 

[dfsobral]

that was for the second rule

for the today you need another rule, the one you place

 

[jtakw]

Hi,

Try my formula in my sample cell C1 for your CF formula:

Book1
	A	B	C
1	Tue 1/16/2018		TRUE
2	Wed 1/17/2018		FALSE
3	Thu 1/18/2018		FALSE
4	Fri 1/19/2018		FALSE
5	Sat 1/20/2018		FALSE
6	Sun 1/21/2018		FALSE
7	Mon 1/22/2018		FALSE
Sheet14

Cell Formulas
Range	Formula
C1	=WEEKDAY(A1,2)=IF(AND(WEEKDAY(TODAY(),2)=4,OR(WEEKDAY(A1,2)>5,WEEKDAY(A1,2)=1)),WEEKDAY(A1,2),IF(WEEKDAY(TODAY(),2)<=3,WEEKDAY(TODAY(),2)+2,IF(WEEKDAY(TODAY(),2)=5,2,2)))

Should work for all your requirements.