cell to be populated with a coloured symbol

[Rubber Beaked Woodpecker]

Hi I am writing a sheet for excel mobile so vba cannot be used.

I would like a cell to be populated with a coloured symbol depending on a condition. Would this be possible using a formula?

A1 = Apple ?
B1 = Banana ?

 

[Joe4]

I am not 100% clear on your question, but it sounds like it may be something that can be done with Conditional Formatting, where certain formats are applied to certain cells depending on certain conditions/formulas.

Have you looked into Conditional Formatting?
See: Conditional Formatting in Excel
or one of the many other documents/tutorials/videos that exist out on the Web.

 

[Dan_W]

Like @Joe4, I'm not entirely clear on the question, but as he says, Conditional Formatting is likely the best candidate. Alternatively, if Custom Number Formats are usable on Excel mobile, you could always use the following:

[Color6]?;[Color4]?

Which produces the following against a black background. To get a banana, type a positive number. For an apple, type a negative number. I realise that this is overly literal and not what you were after, but it was a fun custom format to make