I Love Egypt!

Friday, September 6, 2019

How to Highlight a Row in Google Sheets Using Conditional Formatting

Microsoft Excel logo

Should you need to isolate data in Google Sheets based on specific criteria in a cell, you can use conditional formatting to highlight entire rows in your spreadsheet. Here’s how to do it.

Fire up your browser, head to Google Sheets, and open up a spreadsheet with a table of data you want to apply conditional formatting to highlight specific rows.

RELATED: The Beginner’s Guide to Google Sheets

Highlight all the cells inside the table and then click on Format > Conditional Formatting from the toolbar.

Highlight the information in the table, click Format, and then click "Conditional Formatting."

From the panel that opens on the right, click the drop-down menu under “Format Cells If,” and choose “Custom Formula Is.”

Click the drop-down menu and choose "Custom formula is" from the list of rules.

In the “Value or Formula” text box that appears, type the formula to highlight the specific data you want to isolate in this table. For our table, we will use a formula that highlights an entire row if the release year is before 1980. It looks like this: =$D3<1980

Read the remaining 16 paragraphs

from How-To Geek https://ift.tt/2LyCDLB

No comments :

Post a Comment