+ Reply to Thread
Results 1 to 5 of 5

VBA to conditionally format a range that includes blank cells

  1. 07-13-2016, 05:15 AM #1
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    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
    Attached Files Attached Files
    Last edited by The_Snook; 07-13-2016 at 04:17 PM.
    Reply With QuoteRegister To Reply
  2. 07-13-2016, 05:43 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    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.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 07-13-2016, 05:57 AM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

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

    My understanding of your question.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-13-2016, 08:21 AM #4
    peterrc
    peterrc is offline
    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-13-2016, 04:16 PM #5
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1