+ Reply to Thread
Results 1 to 3 of 3

VBA That copies all condtional format background color and replicates actual color on cell

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    13

    VBA That copies all condtional format background color and replicates actual color on cell

    Hey Guys,

    I have multiple conditional formats in my worksheet and some cells where the conditional formats do no apply.
    The conditional format basically turns the cell background color.
    I need a VBA that make the conditional format background color the actual cells background color color.

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: VBA That copies all condtional format background color and replicates actual color on

    what do you mean will you explain again with a sample file?

  3. #3
    Registered User
    Join Date
    03-08-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: VBA That copies all condtional format background color and replicates actual color on

    I have a conditional Format saying

    =AND(OR(C1="open,C1=pen,C1=Close), ISBLANK(S1))

    I want to count how many cells pertain to this Conditional format

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1