Hi All,
I am looking to understand the possible ways of achieving the below either through Automation, formulas or conditional formatting.
On My Monday board, I have a drop down column “Status” and a date column “date raised”. When the Status Column is marked as Not Start (default) and the date raised is over 30 days ago, I want the row to be highlighted red.
I’ve tried using automation, but I haven’t quite been able to achieve anything close using automation.
I’ve tried using conditional formatting alone, but this only allows me to use one condition to highlight the cell.
Therefore i’ve created a new column with a formula but i’ve only been able to get so far. IF{Status}=“Not Started"AND{Date Raised}=TODAY(”>30")TEXT(“Yes”)
Ideally if this element of the formula “IF{Status}=“Not Started"AND{Date Raised}=TODAY(”>30”)" was enough to then highlight the cell red that would be great. However, my thought was that if the conditions met, then it would enter Yes into the cell and using conditional formatting I could highlight the cell a colour based on the “Yes” in the cell.
Hope this makes sense and any guidance on where my formula is going wrong or a better way to implement this would be appreciated.