Tuesday, March 10, 2015

yogi_Conditionally Format Odd Rows By Coloring Them Green Only If The Rows Contain Data


                                           Google Spreadsheet   Post  #1917
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 10, 2012
question by Nico van Zwieten:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/KVhgDgmKZeY
conditional formatting based on ODD or EVEN rows and present data
I'm trying to use conditional formatting in a spreadsheet but i can't figure out the right formule.

I use a spreadsheet which provides a form for the input.
On a second sheet comes through a query on the form sheet data inside.
Now I want all odd rows colors, but not the whole sheet only the rows where data is present.

if I use this formula   =iseven(row())

The whole sheet gets a "zebra print" and if you want to print these sheets there are many empty striped rows instead of a couple of sheets with the data on it.

I try to get an AND function in the formula, which featured whether there are data in the row.
But I don not succeed yet.
Who can help me on the right track?

With regards,
Nico
-----------------------------------------------------------------------------------------------------------------------