Forum Discussion
Solved
Reminder
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.
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.
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.
