Sunday, February 18, 2018

yogi_Conditionally Format Column A by Alternate Day Rows

Google Spreadsheet   Post  #2375

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-18-2018

question by: BDC_pgh
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/4E0-OhzNw2Q;context-place=forum/docs
Google Sheets - Alternate field color from grey to white, every other day
Hello :-)

Here's the sheet:

https://docs.google.com/spreadsheets/d/1W0MljRH5nJju-QP4hAVASj3080TN01XZNLl2NGuXYIM/edit?usp=sharing

Right now I am using conditional formatting to achieve the effect I want, but I have it set up to alternate field color from white to grey for only about a week (see image).

How can I have the date fields alternate between grey and white, every other day, indefinitely?

There's got to be an easier way to achieve this than what I have set up currently.


Thank you!