+ Reply to Thread
Results 1 to 5 of 5

Highlight First Empty Cell In a Row

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    USA
    MS-Off Ver
    Windows 7
    Posts
    45

    Highlight First Empty Cell In a Row

    Hello,

    I am looking to conditionally format the first empty cell in each row.

    In Column A, are different Account Numbers. In Columns B-F, there are different number values associated with each Account Number. Values in each row (i.e. for each Account Number) are filled left to right, without ever skipping a Column. I would like to highlight the first empty cell in each row (i.e. for each Account Number) yellow, as to designate what cell should be filled.

    I have attached an example what the final product looks like in my head, but I am having trouble coming up with a formula that does this.

    Workbook1.xlsx

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Highlight First Empty Cell In a Row

    Select your range of data.

    In conditional formatting use this rule

    =MATCH(TRUE,INDEX($A2:$F2="",0),0)=COLUMN()

    format -- yellow

    Ok
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Highlight First Empty Cell In a Row

    Try

    =COUNTBLANK($A2:A2)=1

  4. #4
    Registered User
    Join Date
    06-26-2013
    Location
    USA
    MS-Off Ver
    Windows 7
    Posts
    45

    Re: Highlight First Empty Cell In a Row

    This works great. Thank you!

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Highlight First Empty Cell In a Row

    You're welcome.

+ 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. [SOLVED] find last empty cell and highlight yellow
    By James__S in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2014, 03:46 PM
  2. [SOLVED] Conditional formatting - highlight cell if it's empty 2 working days before today
    By uhtfgy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2013, 06:20 AM
  3. Highlight entire row between 2 non empty cell
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-25-2013, 10:23 PM
  4. [SOLVED] How to find first and last non empty cell in row and highlight between?
    By Puzzles in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-27-2013, 02:58 PM
  5. [SOLVED] Highlight cell that was changed (from NOT empty value)
    By dainova in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2012, 03:14 PM

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