Results 1 to 7 of 7

Conditional Formatting Won't Highlight Rows

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2022
    Location
    US
    MS-Off Ver
    MS365
    Posts
    3

    Conditional Formatting Won't Highlight Rows

    I've been trying to highlight rows green when one of the cell values in that row is "TRUE" (linked to a checkbox), using conditional formatting. I've looked at over 10 tutorials, yet nothing happens when I enter the formula: =$I4="TRUE" (and I am changing the format to green). I highlighted the cells and I've also tried the formula for D3, I3, A3, and A1 in case it was being weird about selecting a certain cell. But alas, there are no highlights.

    I even followed one of the tutorials exactly; I recreated their chart in a new workbook with the same values in the same cells. I highlighted the cells they did and copy-pasted their formula.

    Nothing.

    I don't know what I'm doing wrong or if this is a problem with Excel itself. I've attached a sample; any tips?
    Attached Files Attached Files
    Last edited by ArielR; 03-16-2022 at 06:01 PM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 01-20-2022, 03:56 AM
  2. [SOLVED] Using Conditional Formatting to highlight rows
    By rgrohman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-08-2021, 09:21 AM
  3. Conditional formatting to highlight both rows
    By windrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2020, 05:21 PM
  4. Conditional Formatting To Highlight Rows
    By melbin in forum Excel General
    Replies: 1
    Last Post: 08-14-2018, 08:41 PM
  5. Replies: 2
    Last Post: 02-14-2017, 04:00 PM
  6. Conditional formatting to highlight rows that repeat
    By bayala87 in forum Excel General
    Replies: 1
    Last Post: 09-24-2015, 01:50 PM
  7. [SOLVED] Conditional Formatting to Highlight Entire Rows
    By christopherw34 in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 04:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1