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?

1 Answer 1


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.

  • 1
    Thank you so much! In conjunction with this formula, how would I make the cell a certain color if it was empty? No date entered?
    – Brenda
    Oct 7, 2014 at 23:57
  • Thanks again, as you can tell I"m new to custom formulas. Would you be able to recommend a site that would help me learn all the rules for these formulas? Like how to change the order of the custom formulas?
    – Brenda
    Oct 8, 2014 at 0:04
  • Thanks again, I'm trying to figure out how I can learn all the rules for custom formulas for google spreadsheets. Here's what I'm trying to do and am so close but it doesn't quite work.
    – Brenda
    Oct 8, 2014 at 14:46
  • If cell is empty, turn the cell blue. If date is less than 180 days in the past, turn the cell green. If date is between 180 and 365 days in the past, turn the cell yellow. If date if 365 days or more in the past, turn the cell red.
    – Brenda
    Oct 8, 2014 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.