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
If E18's text is Moderator and C18's date is 3 weeks ago, format
If E18's text is Administrator and C18's date is 1 month ago, format
(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