+ Reply to Thread
Results 1 to 5 of 5

VBA to conditionally format a range that includes blank cells

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    857

    VBA to conditionally format a range that includes blank cells

    Morning all,

    I'm trying to create a macro that will apply a conditional format to a range to identify which cells haven't been populated. I've attached an example of the data I'm working with along with a bit more narrative outlining my requirement.

    Thanks in advance,

    Snook
    Last edited by The_Snook; 07-13-2016 at 04:17 PM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: VBA to conditionally format a range that includes blank cells

    Please Login or Register  to view this content.
    You can call this above sub (FillColor) in worksheet change event to let it run automatically.

  3. #3
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: VBA to conditionally format a range that includes blank cells

    My understanding of your question.

  4. #4
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: VBA to conditionally format a range that includes blank cells

    Hi,

    Please see the attached - is this what you are after?
    Please note I have not used a macro - does it have to be a macro?

    Regards

    peterrc

  5. #5
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    857

    Re: VBA to conditionally format a range that includes blank cells

    Cheers AB33, nailed it!

    SixthSense and peterrc thanks for your responses but your solutions weren't quite what I was looking for.

    Regards,

    Snook

+ 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] Using concatenate that ignores blank cells and also includes line breaks
    By JohnW12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2016, 05:09 AM
  2. [SOLVED] Getting Blank Cells to Conditionally Format
    By heresteve2 in forum Excel General
    Replies: 4
    Last Post: 09-28-2015, 02:56 PM
  3. [SOLVED] Auto insert blank row. (blank copy of row that includes merged cells)
    By rutts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2013, 07:48 PM
  4. Find the value of the 2nd to last cell in a column that includes blank cells
    By LookIWashed4Supper in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2013, 09:35 PM
  5. [SOLVED] > or = to 0 includes blank cells
    By KJC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2013, 10:00 PM
  6. [SOLVED] conditionally format the first value to the right of a blank cell
    By skoehler9 in forum Excel General
    Replies: 10
    Last Post: 09-14-2012, 04:21 PM
  7. [SOLVED] Counting Cells that includes exact match and also if a cell includes specific text
    By smclachlan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2012, 07:42 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