SOLVED

Reminder

Contributor

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 Replies
best response confirmed by A2Z CF (Contributor)
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.

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