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

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

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

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

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.

Originally Posted by Askalian

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?