Results 1 to 4 of 4

Color-format a cell which contains data in a column based on the color of another cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    2

    Color-format a cell which contains data in a column based on the color of another cell

    Hello Excel experts, I am a macro newbie, but I want to learn (but this time I do not have the time for that) so I turn to your wisdom instead and hope for the best

    My problem is:

    I have a column C which is conditionally formatted where there is text and also a color (blue) for some specific text content, otherwise the color is unformatted.

    Now I want the column to the left (B) which also contains data (numbers) to have the same color as the cell in the C column. (If one cell in column C is blue, then I want the cell in the B column to also be blue).

    How would I go about doing this?

    Thank you for your help in advance
    Attached Files Attached Files
    Last edited by Nit3hawK; 06-27-2013 at 02:19 PM. Reason: Attach an excel file

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