How to use if formula with colour
Hello everybody. I have just signed up in order to solve a problem that i have with excels if formula. My question is :
I have one cell A1 with value 11 and one cell B1 with value Nikos and red background colour.
I try to use the if formula like this : IF(A1>10,B1) so the cell A1 returns Nikos.
My problem is that i want it also to return the red colour of the cell B1 not only the value.
Thanks in advance.
|