Forum Discussion
Solved
Conditional Format Month which changes
Hi all, I have the below parameter and what I would like to do is highlight the minimum month in red to indicate this does not belong to the promotion date In this case October would be the minimu...
I have sorted it 🙂
So I created a Google sheet with dates in and the promotions, those dates they fell in I put in a Y and the prior month I put in P.
Imported this, joined it to the dates table and within the conditional format part I put the rule as if it is P then light green.
I have sorted it 🙂
So I created a Google sheet with dates in and the promotions, those dates they fell in I put in a Y and the prior month I put in P.
Imported this, joined it to the dates table and within the conditional format part I put the rule as if it is P then light green.