0

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

Please try a Custom formula is like so:

=and(A1>today()-365,A1<today()-180)  

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 '14 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 '14 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 '14 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 '14 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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