In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
Google-sheets – How to turn cell yellow if date in cell is between 180 and 365 days in the past
conditional formattingdategoogle sheets
Related Topic
- Google-sheets – How to enter a date in a cell and have the date for one week later automatically fill another cell
- Google-sheets – Highlight a cell if the date in one column is the latest date
- Google-sheets – Conditional Formatting color if today minus cell date is more than 90 days
- Google-sheets – Set conditional formatting on a column that depends on another cell’s text (not value)
- Google-sheets – Google Sheets Conditional Formatting for expiration dates
- Google Sheets – Date Highlighting by Weeks with Starting Date and Cell Range
Best Answer
Please try a Custom formula is like so:
which may be applied not just to A1 but say to the whole of ColumnA if the Range: is
A:A
.