PDF download Download Article
A user-friendly guide to select and highlight a column in your Google spreadsheet
PDF download Download Article

Do you want to make an entire column in Google Sheets a certain color? You can use conditional formatting rules to highlight and apply a color to an whole column of cells based on a certain formula or condition. While you can view conditional formatting rules in iOS, you'll only be able to create and edit them on desktop or mobile with an Android device. Instead, you can choose the "Fill Color" tool to manually highlight a column. This wikiHow will show you how to highlight and change the color of an entire column in Google Sheets using your Windows, Mac, iPhone, or Android device.

Things You Should Know

  • On desktop, click the column letter to highlight it. Right-click, then click "Conditional formatting". Apply a color, then click "Done".
  • On Android, tap the column letter, then the "A" icon. Tap "Conditional formatting". Apply a color, then tap "Done".
  • On iOS, tap the column letter. Tap the "A" icon. Tap "Cell", then select a Fill color.
Method 1
Method 1 of 3:

Using Desktop

PDF download Download Article
  1. Open a spreadsheet in Google Sheets on your web browser. This can be a new or existing spreadsheet. [1]
  2. You can do this by clicking the column letter at the top of the spreadsheet.
    • You can also click any cell in the column, then press CTRL + Space (Windows) or Command + Space (Mac) to highlight the entire column.
    • If needed, you can add another column.
    Advertisement
  3. This will be next to a paintbrush icon.
    • A new panel will open on the right side.
    • You can also click the down-arrow next to the column letter (A, B, C, etc.) or go to Format Conditional formatting .
    • If you have an existing rule in the spreadsheet, click Add another rule .
  4. If you want to highlight the text-filled cells, click the drop-down menu under Format cells if… and select Is not empty .
    • If you want to highlight the empty cells, select Is empty .
    • If you want to apply a formula , select Custom formula is at the very bottom of the drop-down menu. Insert the value or formula.
  5. Click the paint bucket icon to select the highlight color. You can also apply boldness, italics, underline, strikethrough, or change the text color.
    • If you want to choose a Formatting preset, click Default and select the preset.
  6. This is the green button below the Conditional format rules .
    • Your column will be highlighted.
    • You can also highlight duplicate cells.
  7. Advertisement
Method 2
Method 2 of 3:

Using Android

PDF download Download Article
  1. This looks like a green spreadsheet with a white background. [2]
    • Google Sheets is available for Android in the Google Play Store .
    • You must have a Google account to use Google Sheets. If you don't have an account, you can create one .
    • This method will not work on iOS. You can see conditional formatting rules on an iOS device, but you cannot create or edit them. [3]
  2. Scroll through your Recents page and tap an existing spreadsheet or tap the + to create a new one.
  3. This will select the column you want to highlight.
  4. This is the A with lines to its right. You can find this at the top-right corner, next to + .
  5. This will be between Font and Text rotation . A new panel will open.
    • If you have an existing rule in the spreadsheet, tap ADD first.
  6. If you want to highlight the text-filled cells, tap the drop-down menu under Format cells if… and select Is not empty .
    • If you want to highlight the empty cells, select Is empty .
    • If you want to apply a formula, select Custom formula is at the very bottom of the drop-down menu. Insert the value or formula.
  7. You can select from the presets, or tap + to create a custom style.
    • When creating a custom style, you can apply boldness, italics, underline, strikethrough, change the highlight color, or change the text color.
    • To change the highlight color, tap the paint bucket icon and select the color.
  8. This will be at the top-right corner.
    • Your column will be highlighted.
  9. Advertisement
Method 3
Method 3 of 3:

Using iPhone or iPad

PDF download Download Article
  1. This looks like a green spreadsheet with a white background.
    • Google Sheets is available for iOS in the App Store .
    • If you aren't already logged in to your Google account, enter your login details and click Sign in to do so now.
    • This method involves changing the cell color of a column without the use of conditional formatting rules.
  2. Scroll through your Recents page and tap an existing spreadsheet or tap the + to create a new one.
  3. This will select the column you want to highlight.
  4. This is the underlined A . You can find this at the top-right corner, next to + .
    • A pop-up menu will open.
  5. This is to the right of the Text tab.
  6. By default, the Fill color will be white.
  7. Tap a main color in the top row to see different shades. Toggle brightness with the sun icon in the top-right corner of the Fill color menu.
    • The color will be applied immediately.
  8. This will be in the top-left corner of the spreadsheet.
  9. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Thanks to all authors for creating a page that has been read 11,047 times.

      Is this article up to date?

      Advertisement