Drop Down with YES choice but Changes to a check Mark

**tacnola** · 04-29-2021, 09:45 AM

Great day everyone!!

In a cell I have a drop down list that has the choice of YES. Is there a formula that when this word is chosen that a check mark is shown instead of YES.

Currently if I change the cell to show the "Wingdings 2" font, the drop down "YES" word shows as characters, obviously. So, if possible, I need a conditional format formula that will change the font to Wingdings 2 and the "YES" word to "P".

I know what I need...I just don't know how to write the formula, if it's even possible. Can anyone advise or assist?

Thank you
Teresa

**6StringJazzer** · 04-29-2021, 09:58 AM

Conditional formatting can't change the actual value in the cell. In fact, no formula can change the value in a cell that has been entered by a user. Also icon conditional formatting, which can give you a checkmark, can be used on numbers only, not text. One way to solve this would be with a macro.

What are all the values in your dropdown besides YES? If those are chosen, do you want to just show those words, with nothing else special?

**torachan** · 04-29-2021, 10:36 AM

give the attached a trial - small macro in the sheet module.
data validation list YES,NO
no other formatting on sheet required
at present active in sheet range A2:A20

**tacnola** · 04-29-2021, 10:58 AM

Unfortunately, I can't use a Macro or SQL coding due to computer restrictions.

The drop down list will only show YES and NO, (I figured I could figure the NO part out once I got the Yes formula). I wanted to show a check mark in green when yes is chosen and "X" in red for when NO was chosen.

Could I pull those marks from another cell (hidden to the user) when YES/NO is chosen from the drop down? Ugh, I'm pretty sure I answered my own question. lol. I appreciate your help.

**torachan** · 04-29-2021, 11:14 AM

it never fails to amaze me companies attitude towards macros etc.,
if the code is written in by your own IT department far safer than most commercial software packages.
ignorance by management deprives the company of employee efficiency.
torachan.

**6StringJazzer** · 04-29-2021, 11:33 AM

Give this version a try. It's the best I can think of without macros. This allows selection in one cell, uses a white font so you don't see it, and uses another cell to turn it into a numeric value and use conditional formatting to show a check or an X.

**tacnola** · 04-29-2021, 02:15 PM

I agree!! Our work could be so much simpler!!

**tacnola** · 04-29-2021, 02:19 PM

Originally Posted by 6StringJazzer

Give this version a try. It's the best I can think of without macros. This allows selection in one cell, uses a white font so you don't see it, and uses another cell to turn it into a numeric value and use conditional formatting to show a check or an X.

Brilliant! This will have to be the route I take. Thank you for your innovative thinking!
Thank you so much. This will help me out perfectly!

Drop Down with YES choice but Changes to a check Mark

LinkBack

Thread Tools

Rate This Thread

Display

Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Re: Drop Down with YES choice but Changes to a check Mark

Thread Information

Users Browsing this Thread

Similar Threads

Multiple Time Stamps depending on choice in Drop Down List Choice

Only one check mark allows in a group of form control check box

Change check box fill color to unfill and clear check mark

Time in and out with Check mark to check out

Drop down list: unique value's, values based on that choice, search values based on choice

First time adding a check mark. Adding check mark to make one cell toggle between 2 formul

[SOLVED] check box, so when you click on it it inserts a check mark into t.

Bookmarks

Bookmarks

Posting Permissions