Conditionally format Google Sheets cell based on text in a different cell
I would like to format cell D2 based on text in C2. I would like D2 to be colored Red if C2 contains text from a drop down of "No" and be colored Green if the text is "Yes". I have tried custom formula containing =IF C2 ("Yes") which Google Sheets seems to accept but he result is not displayed at all.
Solution
- Select D2 (or D2:D9 or D2:<somewhere further down>)
- Choose Format ► Conditional Formatting
- Format cells if... Custom formula is...
=C2="yes" - Formatting style - choose a green Fill and click Done.
Add new rule then repeat from step 3 with `=C2="no" and a red Fill.
- How can I save the URL(s), after making a copy (event) of a Google Sheets spreadsheet?
- How to make previous dates data from one tab appear in another tab
- Is it possible to generate a summary table of another table?
- Delete last row with value then find
- Replace form response email address with name from master list
- How do I show data from a spreadsheet? it shows "undefined"
- Extract multiple sparsely packed responses to yes/no identifiers while preserving row information
- getLastRow() in Apps Script returns error: "This operation is not allowed on cells in typed columns."
- I can't convert 46809654.36 into a date and time value in Google Sheets
- Google Spreadsheet Last X Rows
- Select rows that contain a specific dropdown value
- How to negate 'isblank' function
- Is it possible get Image from Google Sheets to Google Docs Template when creating
- Byrow formula with reference to last row and last column
- Dynamically update variable in Spreadsheet popup UI element from google Apps Script
- find a column where specific rows contain specific values
- Inserting images into a Sheet as BlobSource using Google Apps Script
- Slack to Google Sheets integration "dispatch failed" error from slash command
- How to make an auto-timestamped row in Google Sheets
- Get the list of all spreadsheets associated with Google account using Sheets API v4
- Conditional criteria in a query formula
- How to Append an Executable SUM Formula to Google Sheets Using Python?
- Using IF and ignoring blanks
- Spreadsheet database with html
- How to select subset of a range in Google Spreadsheet?
- Google Sheets - Index, Match, & Importrange - What is wrong with my formula?
- Vlookup function for criteria contained in a multiple selection drop down list
- How to send pdf email attachment by an Event trigger in Google Apps Script?
- Allow script to edit locked cells
- How to join unique strings in their own column with QUERY?