Need a quick fav,

I need to create an excel sheet with a drop down list - Tick mark and cross sign mark and display that tick mark with green and cross sign mark with red color. i've tried inserting character 2715 and 2714 to get the signs.

eg : Cell A1 - tick
a2 - cross

I then added two rules for each of those cells like

Format cells that contain specific text containing A1 and gave fill with red
Format cells that contain specific text containing a2 and gave fill with green

I then added data validation and i can see a tick and cross in the drop downs but i don't find the color i need ..

I also tried changing the text colors in A1 AND a2 earlier to see if colors but i dont find colors appearing after the pull list is populated.

All i need is tick to show a green font and all the cross mark to be red or other way around..

what may be wrong ?

how to fix ?