+ Reply to Thread
Results 1 to 11 of 11

Highlight blank cell in a selected range of a sheet

  1. 04-18-2013, 11:58 AM #1
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Question Highlight blank cell in a selected range of a sheet

    i AM GLAD TO ANNOUNCE THAT MY FIRST QUES WAS ANS WITH IN TWO DAYS BY EXCEL FORUM

    SO COMING AGAIN WITH HOPES


    CAN SOMEBODY HELP PLZ PROVIDE ME A MACRO OR VBA THAT CAN HIGHLIGHT ALL THE BLANK CELLS IN A SPECIFIED RANGE WITH YELLOW COLOR LETS SAY COLUMN B7 TO H51000

    AFTER HIGHLIGHTING THE BLANK CELL THE CODE GIVES A MSG TOO"PLEASE FILL ALL THE HIGHLIGHTED YELLOW CELLS"

    LETS SAY B7 IS FILLED BUT B8 IS NOT SO IT CAN HIGHLIGHT B8 AND LIKE WISE AHEAD

    AND SHOW A MSG "DATA COMPLETE YOU MAY PROCEED" IF ALL THE CELLS ARE FILLED
    Last edited by ROHAN999; 04-18-2013 at 12:01 PM.
    Reply With QuoteRegister To Reply
  2. 04-18-2013, 12:32 PM #2
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    Plz help sir....
    Reply With QuoteRegister To Reply
  3. 04-18-2013, 01:30 PM #3
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    I have used conditional formatting but its doesnot solve my purpose
    Reply With QuoteRegister To Reply
  4. 04-18-2013, 01:32 PM #4
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    Beacuse at the begining my sheet is blank and when i used conditional formatting after entering something the yellow color goes but the rest of the cells after the last row of my data entry also remains yellow which defeats purpose
    Reply With QuoteRegister To Reply
  5. 04-18-2013, 01:44 PM #5
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet 

    Please Login or Register  to view this content.
    CURRENTLY I AM USING THIS CODE BUT IT DOES NOT STOP AT THE LAST ROW OF DATA ENTRY

    PLZ HELP
    Reply With QuoteRegister To Reply
  6. 04-18-2013, 01:53 PM #6
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet 

    Please Login or Register  to view this content.
    THIS IS ANOTHER TRY BUT THAT IS ALSO NOT WORKING FINE

    PLZ HELP SO THAT WITH THE ACTIVE SHEET AND WITHIN A SPECIFIED RANGE ALL THE BLANK CELLS CAN BE HIGHLIGHTED WITH YELLOW COLOR WITH THE MSG THAT FILL ALL YELLOW COLORED CELLS

    BUT THIS SHOULD BE UPTO LAST DATA ENTRY ROW....
    Reply With QuoteRegister To Reply
  7. 04-18-2013, 01:56 PM #7
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    My data will be with in b7 to i510000

    plz help...
    Reply With QuoteRegister To Reply
  8. 04-18-2013, 01:59 PM #8
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Highlight blank cell in a selected range of a sheet

    According to the forum rules, you are required to wait at least a day before "bumping" your thread and asking for help again

    Thanks
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  9. 04-18-2013, 02:04 PM #9
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    All right sir...i am waiting...

    I apologies
    Reply With QuoteRegister To Reply
  10. 04-19-2013, 09:33 AM #10
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    Plz help me sir..i will be greatful...
    Reply With QuoteRegister To Reply
  11. 04-20-2013, 08:50 AM #11
    ROHAN999
    ROHAN999 is offline
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    726

    Re: Highlight blank cell in a selected range of a sheet

    Any body any help in this regard will be appreciated..
    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)

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