+ Reply to Thread
Results 1 to 4 of 4

Remove Highlighted colour

  1. #1
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Remove Highlighted colour

    Hi,

    Macro will be placed in macro.xlsm & book1.xlsx & Book2.xlsx are located at different place so the path of of both the files should be hardcoded in the macro
    If cells in column A of sheet1 of book2.xlsx matches with cells of column A of book1.xlsx then dont do anything & If it doesnt matches then remove all the highlighted colour in that row of book2.xlsx
    (May be it has highlighted colour or it may not have highlighted colour but if it doesn't matches then if highlighted colour are present then remove the highlighted colour, do not clear the data or change the data )

    highlighted colour may be anywhere in that row or it will not be there

    Thnx
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Remove Highlighted colour

    Hi dumdumbum,

    Might just be me but I feel like I've answered this for you previously?

    That said, though there's probably a more succinct way of doing it this will do the job:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Remove Highlighted colour

    Thnx Alot Trebor76 Sir for helping me in solving this problem Sir
    Have a Awesome Day Sir

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Remove Highlighted colour

    You're welcome and thank you for marking the thread as solved. Thanks too for the rep

+ 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. how to record dates when cell is highlighted by colour
    By dougers1 in forum Excel General
    Replies: 19
    Last Post: 09-16-2014, 09:32 AM
  2. If F is less than 40% of E, I want F to be highlighted another colour
    By rachelroe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2014, 03:00 AM
  3. Need count for different colour highlighted cells
    By Sankara Narayanan in forum Excel General
    Replies: 5
    Last Post: 11-08-2013, 06:06 AM
  4. Max & min values highlighted by font colour
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-10-2011, 12:00 PM
  5. Excel 2007 : How To NOT Print Colour Highlighted Cells
    By dandino in forum Excel General
    Replies: 7
    Last Post: 08-31-2009, 05:02 PM
  6. Sum if Cells Highlighted Particular Colour
    By uberchick in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-06-2008, 04:20 AM
  7. Colour of highlighted cells
    By teakwood in forum Excel General
    Replies: 0
    Last Post: 05-08-2006, 11:10 AM

Tags for this Thread

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