Result based on shading of adjacent cell

Hi,

I would like to create an IF function that will return the word "Apple" if the adjacent cell is shaded a certain colour.

Is this possible? If so, could someone please suggest a solution.

Thanks very much!

Hello
My suggestion is to create your own function, something like :

Please Login or Register  to view this content.

Then use the =IF(test(),"apple","") in the adjacent cell.

Regards