+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting of empty row that are between non empty rows

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    israel
    MS-Off Ver
    Excel 2007
    Posts
    11

    Conditional formatting of empty row that are between non empty rows

    Hi,
    i have a range that users need to fiil with data from a1:a1000.
    sometimes they skip rows for example they fill the cell a1 and then they skip a2 and fill a3.
    I need a data validation formula to fill in yellow all those empty line but not the lines that that below them there is nothing.
    for example if the last filled row is 100 then data validation will fill yellow only in empty rows above 100 and not below.

    thanks

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Conditional formatting of empty row that are between non empty rows

    I'm assuming that you want CF formula and not Data validation.
    Select $A2 to $A1000
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Delete Empty Rows and empty columns from the word table
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 10:51 AM
  2. Time empty conditional Formatting?
    By ukdjaj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2014, 02:11 PM
  3. [SOLVED] Conditional formatting - empty rows
    By suhi in forum Excel General
    Replies: 6
    Last Post: 04-26-2012, 07:08 AM
  4. Deleting empty rows if specific cell in row is empty
    By csynic in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 01:43 AM
  5. How to conditional formatting for empty cell value
    By vdongen in forum Excel General
    Replies: 2
    Last Post: 10-14-2010, 07:00 AM
  6. Conditional Formatting - Set value to empty cell
    By efernandes67 in forum Excel General
    Replies: 1
    Last Post: 06-07-2010, 11:37 PM
  7. Autofilter/delete empty rows is deleting non-empty rows!
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2010, 12:31 PM
  8. Conditional formatting with empty cell
    By dadel in forum Excel General
    Replies: 13
    Last Post: 07-08-2009, 10:24 AM

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