Google Spreadsheet Help

Closed
Report
Posts
1
Registration date
Monday January 1, 2018
Status
Member
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

Basically

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