Google Sheets Conditional Formatting - advance
Google Sheets Conditional Formatting - Advance
How to use a full row conditional formatting on Google Sheet
To format an entire row based on the value of one of the cells in that row:
On your computer, open a spreadsheet in Google Sheets.
Select the range you want to format, for example, columns A4:F.
Click Format and then Conditional formatting.
Under the "Format cells if" drop-down menu, click Custom formula is. If there's already a rule, click it or Add new rule and then Custom formula is.
For example, if you want to make the whole row red if the value in column F is "Pending", write the formula like "=regexmatch($A4,"Pending")"
Choose other formatting properties.
Click Done.
How to use Google Sheets
Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people.
Step 1: Create a spreadsheet
To create a new spreadsheet:
Open the Sheets home screen at sheets.google.com.
Click New Add. This will create and open your new spreadsheet.
You can also create new spreadsheets from the URL sheets.google.com/create.
link :
How to use Google Sheets :
https://support.google.com/docs/answe...
What can you do with Docs? :
https://gsuite.google.com/learning-ce...
Create, view, or save a file :
https://support.google.com/docs/answe...
~-~~-~~~-~~-~
Please watch: "how to download YouTube videos on mobile device "
• Video
~-~~-~~~-~~-~
Watch video Google Sheets Conditional Formatting - advance online without registration, duration hours minute second in high quality. This video was added by user ClickPoint 28 May 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,26 once and liked it 3 people.