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
Bookmarks