How can I make excel highlight a day of every current week

[jorgef72]

My example, I have a row with dates of every Sunday of each month in a year (only the Sunday), what I am struggling with is when I open the file I would like to using conditional formatting to highlight the Sunday of the current week so that I know which Sunday is coming up.

 

[RCBricker]

My example, I have a row with dates of every Sunday of each month in a year (only the Sunday), what I am struggling with is when I open the file I would like to using conditional formatting to highlight the Sunday of the current week so that I know which Sunday is coming up.

try this

=AND(YEAR($A1)=YEAR(TODAY()),WEEKNUM($A1,2)=WEEKNUM(TODAY(),2))

 

[MaxSmart]

Hi,

Set up a helper column as I have done in column B in the example.

Then you can perform conditional formatting based on the value in the helper column

Excel 2012
	A	B
1	Date	Next up
2	07-Feb-16
3	14-Feb-16
4	21-Feb-16
5	28-Feb-16
6	06-Mar-16
7	13-Mar-16
8	20-Mar-16	THIS
9	27-Mar-16
10	03-Apr-16
11	10-Apr-16
12	17-Apr-16
13	24-Apr-16
14	01-May-16
15	08-May-16
16	15-May-16
17	22-May-16
18	29-May-16
19
Sheet1

Excel 2012
	B
2
Sheet1

Cell Formulas
Range	Formula
B2	=IF((A2-TODAY())<7,IF((A2-TODAY())>=0,"THIS",""),"")

Hope that helps

Regards........Max

 

[Peter_SSs]

My example, I have a row with dates of every Sunday of each month in a year (only the Sunday), what I am struggling with is when I open the file I would like to using conditional formatting to highlight the Sunday of the current week so that I know which Sunday is coming up.

Welcome to the MrExcel board!

You could also try this Conditional formatting.

Excel Workbook
	A
1	Date
2	Sun 7-Feb-16
3	Sun 14-Feb-16
4	Sun 21-Feb-16
5	Sun 28-Feb-16
6	Sun 6-Mar-16
7	Sun 13-Mar-16
8	Sun 20-Mar-16
9	Sun 27-Mar-16
10	Sun 3-Apr-16
11	Sun 10-Apr-16
12	Sun 17-Apr-16
13	Sun 24-Apr-16
CF Upcoming Sunday

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =A2=MEDIAN(A2,TODAY(),TODAY()+6)	Abc