Highlight Row Based on Cell Value

From Renee Brooks
Revision as of 20:41, 10 March 2023 by Wikimaster (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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=14"