Forum Discussion
Conditional Formatting for quarters
Hi, I'm trying to construct an AND function that will conditionally format a cell in Column H based on two criteria: If the corresponding cell in Column H says "Quarterly" and; If the correspo...
Let's say you want to apply this to H2:H50.
Select this range, H2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(H2="Quarterly", QUOTIENT(MONTH(G2)-1, 3)=MOD(QUOTIENT(MONTH(TODAY())-1, 3)-1, 4))
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.