## How to: Create greenbar spreadsheets

Call

To begin, open a spreadsheet software like Excel or Libreoffice and follow the instructions noted in the caption.

**************************************************************************************

Go straight to the picture portion for the tutorial aspect of this how-to. The writing that immediately follows is meant to explain the inner-workings of the MOD() function and the row() function that makes the highlight every-other-line in a spreadsheet trick work. MOD() function is a mathematical modulus function that will return a value of either 0 or 1.Â The row() and column() function will return the current row number or column number, depending on which one is called. The combination of these two functions MOD(row(),2), will take the current row number, divide it by 2, and yield either a value of 0 or 1, which will trigger the conditional formating to select one or the other.

Because Microsoft products are supported by Visual Basic, whereas Libreoffice is of C++, Java, and Python lineage, there may be variations in the programming syntax. I hope this program toggling trick is useful for your highlight-every-other-line on a spreadsheet exercise.