Saturday, October 18, 2014

yogi_Coditionally Format Row (highlight from columns A To L) Where Membership Date In Column C Is More Than 1 Year

                 Google Spreadsheet   Post  #1798
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-18-2014
post by  figure2:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/sRnob32orWw)
Identifying members not in good standing
Our arts group maintains a list of members which includes data such as membership level, email, phone, address and date joined/renewed.

Is there a way to set the "Date Joined/Renewed" column so when one calendar year has passed from their joining or renewing, that member's row will change, either text or background color? We would like to have an easy way to identify members whose membership status has lapsed so they can be sent reminders to renew.

Thanks.

---
Thanks Bob. I made a sample site using the same column headers as our membership spreadsheet. Column "C," "Member Date" is the members join/renewal date that we want to detect when it expires:
https://docs.google.com/spreadsheets/d/16_-gVsbHQbvPVX3ZSMoej1QBn5dvxMFrxDWmr2ihg6Q/edit#gid=0

------------------------------------------------------------------------------------------------------