Results 1 to 8 of 8

Concatenate Values | Retain Conditional Formatting of the Source

Threaded View

  1. #2
    Registered User
    Join Date
    10-04-2013
    Location
    Irving, Texas
    MS-Off Ver
    Office 2003-07-10-13
    Posts
    34

    Re: Concatenate Values | Retain Conditional Formatting of the Source

    I'm confused by the conditional formatting piece?

    Which of the cells has conditional formatting?
    If all the cells, then do they all have the same criteria?
    If so, and the various criteria produce different resulting formats (based on the different values shown in each cell), what is the order of priorty for the applied formats to A1?

    Also, what is an example of what the existing value(s) would be for the two percentage formatted entries in the concatenated string?
    Correction/clarification: what is an example of the EXISTING values in data2 and data5 and do the values already represent percentages in need of the symbol, or would they need tobe multiplied by 100 and then have the symbol attached?
    For example:
    Data2 has a value of .1234, would normally format to a percentage of 12.34%
    or, is .1234 already in a percent and need to be rounded to 0.12%
    Last edited by Bilbo_Baggins; 10-04-2013 at 10:14 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro to merge values from one column into one cell and retain source formatting.
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 12-05-2012, 04:41 PM
  2. VBA to Retain the Conditional Formatting with an Advanced Filter
    By mmctague in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2012, 02:09 PM
  3. Replies: 1
    Last Post: 08-16-2012, 10:51 AM
  4. Retain conditional formatting when pasting new data into cells, and how to copy it
    By NatGunod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2012, 10:27 AM
  5. Concatenate cells and retain formatting
    By NewYorkVanilla in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-20-2009, 02:17 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