Highlight Row Based on Cell Value: Difference between revisions

From Renee Brooks
Jump to navigation Jump to search
VisualWikitext
Created page with "thumb|Use the formula <code>=$G1=true</code> if you are messing with Check Marks in the G Column - Otherwise it is <code>=$G1="ValueToTrigger"</code> # Create your table of data # Select your entire table of data # Click on "Format" and then "Conditional Formatting" # Create a new Conditional Formatting Rule ## Set the range to the table of data ## Change the rule to be "Cust..."
 
No edit summary
 
Line 8: Line 8:
## Change the rule to be "Custom formula is"
## Change the rule to be "Custom formula is"
## Use the formula <code>=$G1=true</code> if you are messing with Check Marks in the G Column - Otherwise it is <code>=$G1="ValueToTrigger"</code>
## Use the formula <code>=$G1=true</code> if you are messing with Check Marks in the G Column - Otherwise it is <code>=$G1="ValueToTrigger"</code>
[[Category:Google Sheets]]

Latest revision as of 20:42, 10 March 2023

Use the formula =$G1=true if you are messing with Check Marks in the G Column - Otherwise it is =$G1="ValueToTrigger"
  1. Create your table of data
  2. Select your entire table of data
  3. Click on "Format" and then "Conditional Formatting"
  4. Create a new Conditional Formatting Rule
    1. Set the range to the table of data
    2. Change the rule to be "Custom formula is"
    3. Use the formula =$G1=true if you are messing with Check Marks in the G Column - Otherwise it is =$G1="ValueToTrigger"
Retrieved from "https://www.wiki.reneebrooks.com/index.php?title=Highlight_Row_Based_on_Cell_Value&oldid=15"