Aug 24 2022 09:11 AM
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.
Aug 24 2022 09:19 AM
SolutionSelect 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.
Aug 25 2022 06:19 AM
Aug 24 2022 09:19 AM
SolutionSelect 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.