How To Alternate Colors in Google Sheets | Scribe

    How To Alternate Colors in Google Sheets

    • Alejandra Arciniegas |
    • 10 steps |
    • 34 seconds
    • Google SheetsGoogle Sheets
    1
    The first thing you should do, is to navigate to Google Sheets.
    2
    Once you open you document click and drag the mouse over the cells that you want to apply the format to.
    3
    The, click on "Format" in the upper bar.
    4
    Now, select "Conditional formatting" from the dropdown.
    5
    Now, you should click on the dropdown below "Format rules".
    6
    Scroll all the way to the bottom, and click on"Custom formula is".
    7
    Now, click on the "Value or formula" field.
    8
    And type [[=MOD(ROW(),2)]]
    9
    Now, you can click on "Done".
    10
    And that's all! Pretty easy, right?