Conditional coloring symbol

[primasatria]

Dear all,

I have this function:

= IF(K20<M20,"▲", IF(J20=L20,"●","▼"))

And I need to coloring with these criteria:
▲ = Red
● = Yellow
▼ = Green

Can you please help me?

Thank you,
prima

 

[sxhall]

Use conditional formatting...

 

[Fluff]

Duplicate to: Conditional coloring symbol based on function in Excel

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.