Display colored emoji based on cell value
Solved
Kikochikitin
Posted messages
2
Status
Membre
-
Stephanie -
Stephanie -
Hello everyone,
I'm asking a question here on a topic already discussed on the forum, but I couldn't adapt the solutions proposed to other users:
In row 4 column AV, I enter a value between 1 and 10
In row 4 column I, I would like the previously entered value to return:
- a green smiling emoji if value AV is between 1 (inclusive) and 4 (inclusive)
- an orange flat mouth emoji if value AV is between 5 (inclusive) and 7 (inclusive)
- a red upside-down mouth emoji if value AV is between 8 (inclusive) and 10 (inclusive)
Once this operation is done, I would like to be able to drag my formula down vertically.
Thank you in advance
http://www.cjoint.com/c/FDoiL3lfVuJ
I'm asking a question here on a topic already discussed on the forum, but I couldn't adapt the solutions proposed to other users:
In row 4 column AV, I enter a value between 1 and 10
In row 4 column I, I would like the previously entered value to return:
- a green smiling emoji if value AV is between 1 (inclusive) and 4 (inclusive)
- an orange flat mouth emoji if value AV is between 5 (inclusive) and 7 (inclusive)
- a red upside-down mouth emoji if value AV is between 8 (inclusive) and 10 (inclusive)
Once this operation is done, I would like to be able to drag my formula down vertically.
Thank you in advance
http://www.cjoint.com/c/FDoiL3lfVuJ
2 réponses
Hello
you cannot (at least as far as I know) use icons directly outside of the cell that contains the condition (i.e., AV in your case)
try this if possible:
format of field I > Wingsdings font (size as needed)
formula in I4
=IF(AV4="";"";IF(AV4<=4;"J";IF(AV4<=7;"K";"L")
(uppercase letters)
and for colors, use a conditional formatting by formulas with
I4="J" or I4="K" or I4="L"
best regards
The quality of the response mainly depends on the clarity of the question, thank you!
you cannot (at least as far as I know) use icons directly outside of the cell that contains the condition (i.e., AV in your case)
try this if possible:
format of field I > Wingsdings font (size as needed)
formula in I4
=IF(AV4="";"";IF(AV4<=4;"J";IF(AV4<=7;"K";"L")
(uppercase letters)
and for colors, use a conditional formatting by formulas with
I4="J" or I4="K" or I4="L"
best regards
The quality of the response mainly depends on the clarity of the question, thank you!
on this site: https://answers.microsoft.com/fr-fr/office/forum/office_2010-excel/cr%C3%A9er-des-jeux-dic%C3%B4ne-pour-excel/500da856-6167-e011-8dfc-68b599b31bf5?auth=1
a custom number format is suggested: [Red][>7] "L"; [Green][<5] "J"; [Yellow] "K"; @
this could be an alternative to a conditional formatting.
best regards
As mentioned elsewhere, it's not a big deal for the color!!!
Thank you anyway for the information!!!
I did not mention a formula but a custom format.
Best regards