+ Reply to Thread
Results 1 to 3 of 3

My Conditional Formatting does not highlight rows, only cells in a column

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-15-2009
    Location
    Austin, TX - USA
    MS-Off Ver
    Microsoft 365
    Posts
    120

    My Conditional Formatting does not highlight rows, only cells in a column

    Hello! I can't figure out why my conditional formatting does not work as intended: I have 5 columns - A, B, C, D, E - and I simply want the rows, where cell E is empty, to be green and the rows, where cell E has a value - turn red. Pretty straight forward. In case individual cell format matters, I have entire columns A, B, and C with default "General" formatting and remaining D and E - as Date.

    My formulas look as follows:
    Formula: copy to clipboard
    =ISBLANK(E2)
    for green and
    Formula: copy to clipboard
    =NOT(ISBLANK(E2))
    for red; both applied to
    Formula: copy to clipboard
    =$A$2:$E$99999
    What happens is that only cells in the A column are turning red of the rows where the date value in column E is entered.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: My Conditional Formatting does not highlight rows, only cells in a column

    =ISBLANK($E2)
    Use the "$" anchor, then when the cell in column E is blank the whole row changes color. Without the "$", each cell in the row is checked for blank and only that cell will change color.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    10-15-2009
    Location
    Austin, TX - USA
    MS-Off Ver
    Microsoft 365
    Posts
    120

    Re: My Conditional Formatting does not highlight rows, only cells in a column

    Wow, that was super easy! Thank you very much, protonLeah!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 11-08-2013, 05:57 AM
  2. Conditional Formatting - Highlight All Rows in Table with Errors in Cells
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2013, 03:34 PM
  3. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  4. [SOLVED] Conditional Formatting to Highlight Entire Rows
    By christopherw34 in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 04:12 PM
  5. Replies: 12
    Last Post: 05-05-2012, 03:58 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