View Single Post
 
Old 08-11-2015, 01:12 AM
sake sake is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Aug 2015
Posts: 4
sake is on a distinguished road
Question 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.
Reply With Quote