Icon Set Conditional Formating

[Ehtisham Ali]

Hi Everyone,

Please refer to the attached sheet. In yellow cell i have applied a formula to randomize data now on the basis of data I want to conditional format the same yellow cell to show some icon.

Boy with a green Flag
Girl with a Yellow Flag.

Good enough if possible without any helper cell.

 

[bobhc]

Not sure where you are going to find the icons you have mentioned or why you need them, this site shows how to create icons but nothing close to what you want.


http://blog.contextures.com/archives/2013/09/03/create-your-own-excel-icon-set/


.

 

[Ehtisham Ali]

Not sure where you are going to find the icons you have mentioned or why you need them, this site shows how to create icons but nothing close to what you want.


http://blog.contextures.com/archives/2013/09/03/create-your-own-excel-icon-set/


.

Hi
Icons already exists in Excel conditional formatting Icon Set I don't want to create them.

What I actually want is to format the yellow cell to show appropriate FLAG icon.

hope you got my requirement.

 

[bobhc]

Boy with a green Flag
Girl with a Yellow Flag.

Icons already exists in Excel conditional

You have better eyesight than me, for I do not see a boy or girl with a flag.



.

 

[Asheesh]

Hi Ehtisham,

AFAIK, bob is right coz those will work on numbers, percentages, percentiles and Formulas...And i dont think in this case formula option will work...others may have a say..

However, I have created a possible work around...but using different cell...you may check if this helps...

 

[Ehtisham Ali]

Hi Asheesh,

I saw your work its good, but that is not what I require.

Anyways thanks for your help I think it is not possible then.