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 corresponding cell in Column G displays a date that occurred in an annual quarter prior to the one we’re currently in. 

For example, if the date in column G is 6/1/2024, and Column H says “quarterly,” I want the cell in Column H to be highlighted red, since 6/1/2024 was in Quarter 3, and we’re currently in Quarter 4. 

I’m still pretty new to excel formulas, and I’ve tried finding a solution to this online, but none of the situations I’ve found solutions for are quite like mine. 

​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 corresponding cell in Column G displays a date that occurred in an annual quarter prior to the one we’re currently in.  For example, if the date in column G is 6/1/2024, and Column H says “quarterly,” I want the cell in Column H to be highlighted red, since 6/1/2024 was in Quarter 3, and we’re currently in Quarter 4.  I’m still pretty new to excel formulas, and I’ve tried finding a solution to this online, but none of the situations I’ve found solutions for are quite like mine.   Read More

​