I am trying to create a Google sheet to track payments for a team. I want a cell to turn red if a value hasn't been entered by the 1st of the month. I have 2 other formats already set up to change to green or yellow depending on full payment or partial payment.
Google-sheets – Conditional Format IF Blank by 1st of Month
conditional formattinggoogle sheets
Related Topic
- Conditional Formatting with Asterisk Character in Google Sheets
- Google Sheets – How to Apply Relative Reference in Conditional Formatting
- Google-sheets – How to conditionally format text color to match across sheets in Google Sheets
- Google-sheets – Conditional Formatting using Google Sheets
- Google-sheets – Google Sheets – Conditional Formatting question
- Google-sheets – Conditionally format if date is same/greater or smaller than current date
- Google-sheets – Conditional Formatting only seeming to apply if the ‘Less than’ criteria is selected
Best Answer
If a payment has not been received on an transaction by the first day of the following month, you want the payment cell to appear red.
Assume:
Use this formula as a "custom formula" for Column C in Conditional formatting.
=and(isblank(C2),today()>EOMONTH(A2,0)+1)
Explanation:
AND()
Returns TRUE, if both expressions are trueisblank()
- checks that no payment has been received; returns TRUE/FALSEtoday()>EOMONTH(A2,0)+1)
- is todays date grater than the first day of the month following the transaction date. TRUE/FALSE