+ Reply to Thread
Results 1 to 6 of 6

Getting the color of a cell simultaneously with its value.

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    48

    Getting the color of a cell simultaneously with its value.

    Hello,

    I have this problem :

    Let's have CELL A2 with 20 as value and BLUE as background color.
    Let's have CELL A3 with 30 as value and GREEN as background color.

    In cell B4, I have the formula : =IF(B3=0;A2;A3)

    Of course, I will get :

    - 20 in B4 if B3 = 0
    - 30 in B4 if B3 <> 0.

    But how can I get also the same color in B4 than the colors of A2 (BLUE) or A3 (GREEN), when the formula is calculated ?

    Thanks for the kind help.
    Best.
    Frederic

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    181

    Re: Getting the color of a cell simultaneously with its value.

    Use Conditional Formatting ... apply it twice to the cell ... use a formula as the test in each case, test for B4=A2 and apply BLUE ... test for B4=A3 and apply GREEN

  3. #3
    Registered User
    Join Date
    05-31-2012
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Getting the color of a cell simultaneously with its value.

    Thanks, but it does not really help me.

    To be concise in my explanations, I have explained the problem only with 4 cells A2, A3, B3, B4

    But in fact, there are 80 possible B4 (let's say B4 to B84) cells and 80 variable A2 or A3 (let's say A2 to A82) and the colors of A2 to A82 are themselves with conditionnal formatting...

    Therefore, I really need to export the colors with the numbers as I don't think it can be easy to put conditionnal formatting in the B4 to B84 cells.

    If you have any idea ?

    Thanks in advance.
    Best.
    Frederic

  4. #4
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    181

    Re: Getting the color of a cell simultaneously with its value.

    So why can't you apply the same conditional formatting to column B?

  5. #5
    Registered User
    Join Date
    05-31-2012
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Getting the color of a cell simultaneously with its value.

    Because A2 to A82 cells change themselves their color rather randomly with conditional formatting and trying to find rules for B cells would be a titanic task and it would be far more easy just to export the colors of the A column cells, together with their values.

  6. #6
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    181

    Re: Getting the color of a cell simultaneously with its value.

    Quote Originally Posted by Askalian View Post
    Because A2 to A82 cells change themselves their color rather randomly with conditional formatting and trying to find rules for B cells would be a titanic task and it would be far more easy just to export the colors of the A column cells, together with their values.
    Explain how the colours of A2:A82 can change randomly if you have set the Conditional Formatting? If they follow a set of rules in CF, then how is it that the same rules would not work on column B?

+ 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. [SOLVED] Unable to simultaneously set both HSL and RGB color values.
    By isychos in forum Excel General
    Replies: 4
    Last Post: 11-08-2018, 04:36 PM
  2. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  3. Replies: 2
    Last Post: 06-12-2017, 09:38 AM
  4. Highlighting cells same color simultaneously in 2 sheets
    By zapa98498 in forum Excel General
    Replies: 3
    Last Post: 08-20-2014, 12:23 AM
  5. [SOLVED] Nested for each loops, moving to next cell on both simultaneously
    By cs454 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2014, 10:48 AM
  6. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  7. [SOLVED] Protect sheets with same cell ranges simultaneously
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-29-2013, 04:58 AM

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