Google Spreadsheet Help [Closed]

Registration date
Monday January 1, 2018
Last seen
January 1, 2018
I'm looking to create a very intricate spreadsheet on google which requires a custom formula, problem is, can't find what I need.

I have a cell that has a date in it. It needs to reference another cell to check the text then if it matches, check the date of itself and if it is a certain amount determined by the text of the previous cell change it's color


1 rule:
If E18's text is Moderator and C18's date is 3 weeks ago, format

1 rule:
If E18's text is Administrator and C18's date is 1 month ago, format

1 rule:
(This part is automatic in google and I understand) if none of the above exist (from google going down the list) and cell is not empty, format

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!