+ Reply to Thread
Results 1 to 5 of 5

need a macro to convert conditionally formatted cells color to excel colors.

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    4

    need a macro to convert conditionally formatted cells color to excel colors.

    Hi,

    i m trying to search a code to convert conditionally formatted colors to normal excel colors. because i have another macro which puts specific values in those colored cells so far i m failed to do so. please also let me know how to evaluate conditional formatting formula in vba.

    BR.
    IZ

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,803

    Re: need a macro to convert conditionally formatted cells color to excel colors.

    Tell us specifically what is in the cells that needs to be formatted. What type of formatting is required for those cells and in particular where are they located, ie. column B?

    Specificity is important when building VBA code.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,410

    Re: need a macro to convert conditionally formatted cells color to excel colors.

    you might find the DisplayFormat object useful

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    09-28-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: need a macro to convert conditionally formatted cells color to excel colors.

    Thanks Alansidman, i have attached my sheet. in which two macro's. in which 2 macro's. 1 is putting values to conditionally formatted cells (which is not reading the conditionally formatted colors). I am trying to build second one to give excel colors to conditionally formatted colored cells but i failed to do so.

    please check.

    Regards,
    IZ
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-28-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: need a macro to convert conditionally formatted cells color to excel colors.

    Thanks Andy you have solved my problem

    Thanks Everyone

+ 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: 6
    Last Post: 02-16-2013, 05:12 AM
  2. Replies: 10
    Last Post: 11-08-2010, 10:36 AM
  3. Replies: 2
    Last Post: 09-22-2010, 07:54 PM
  4. Macro to Delete Conditionally Formatted Cells
    By luckylindy345 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2008, 09:07 AM
  5. [SOLVED] how do i concatenate conditionally formatted cells in excel
    By Sandwiches2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-13-2006, 09:45 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