Results 1 to 5 of 5

How to copy a conditional format as an ACTUAL format?

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    Logoo
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question How to copy a conditional format as an ACTUAL format?

    Hi,

    I want to copy a group of cells that have a conditional format (e.g. background color for cells if a condition meets) and paste only the format, but not keep the conditional format rules.

    For example, I have 3 columns in a table,
    [Product Name]...... [Last Year Sales]...... [Current Year Sales]...... [Comparison]
    Product1...... 100,000...... 90,000...... (The backgrond color of [Comparison] becomes red when [Last Year Sales] < [Current Year Sales])
    ... ... ... ...

    If I only copy/paste the column [Product Name] and the column [Comparison] to another spreadsheet, how to keep the red background color for the cell of [Comparison] for "Product1"?

    Thank you in advance.
    Attached Images Attached Images

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