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!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:

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!