Google Spreadsheet Help [Closed]

Runelixx 1 Posts Monday January 1, 2018Registration date January 1, 2018 Last seen - Jan 1, 2018 at 04:25 PM - Latest reply: Ambucias 52527 Posts Monday February 1, 2010Registration dateModeratorStatus June 18, 2018 Last seen
- Jan 1, 2018 at 04:43 PM
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
See more 

1 reply

Ambucias 52527 Posts Monday February 1, 2010Registration dateModeratorStatus June 18, 2018 Last seen - Jan 1, 2018 at 04:43 PM
0
Thank you
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator