How To Do Contidional Formating In Google Sheets | Scribe

    How To Do Contidional Formating In Google Sheets

    • Alejandra Arciniegas |
    • 7 steps |
    • 42 seconds
    • Google SheetsGoogle Sheets
    1
    Applying conditional formatting in Google Sheets is really simple! The first thing you should do is to navigate to Google Sheets.
    2
    Once you have your spreadsheet opened, you should select the column or row that you want to apply the conditional formatting to.
    3
    Then, you should click on "Format".
    4
    Then, you should select "Conditional formatting" from the dropdown.
    5
    Then, you should click on the dropdown below "Format rules".
    6
    You will find many formatting options that can either be applied to text, numbers and even dates! Select the one you need or prefer. In this case, I will be choosing the "text contains".
    7
    Once you select the type of format you want, click on the "Value or formula" field and type the text that you want to be highlighted.