+ Reply to Thread
Results 1 to 3 of 3

Highlight Cells based on its values

  1. #1
    Registered User
    Join Date
    03-16-2015
    Location
    Bangkok
    MS-Off Ver
    2007
    Posts
    28

    Highlight Cells based on its values

    Hello all beautiful people,

    Could you please help me implement VBA macro to highlight all the cells in my active worksheet that has the value #N/A, starting from cell B2 until the last row and last column.

    Thank you

    VKu

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Highlight Cells based on its values

    Hi,
    Try this....
    Please Login or Register  to view this content.
    If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Highlight Cells based on its values

    Maybe this.....
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. Replies: 4
    Last Post: 11-18-2014, 04:12 AM
  2. Highlight all cells in a column based on values in two different cells
    By lbrasfield in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2014, 06:26 AM
  3. Replies: 4
    Last Post: 07-25-2014, 05:17 AM
  4. [SOLVED] VBA help need to highlight the cells based on the dates and insert respective cell values.
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2014, 11:14 PM
  5. Replies: 23
    Last Post: 09-25-2009, 07:39 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