Reminder

[A2Z CF]

Hi everyone, I tried many formulas to solve this situation where I just want my reminder cell to be highlight or flashing on every 2nd and 4th Thursdays of the month but didn’t seem to work properly.

The date cell =Today() is located in the Batch-tab at Column A Row# 2 and the reminder cells are Columns B, C, D, and E Row# 64. I’ll appreciate any solution to this situation very much and thank you in advance.

[#2 · Accepted solution]

@A2Z CF 

Select the cells you want to highlight.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=AND(WEEKDAY(TODAY())=5, OR(AND(DAY(TODAY())>7, DAY(TODAY())<15), AND(DAY(TODAY())>21, DAY(TODAY())<29)))

Click Format...

Specify the desired formatting in the Fill and/or Font tabs.

Click OK, then click OK again.

[#3]

Thank you so much for this formula. It works wonderfully! I appreciate it very much.