I am trying to find and highlight any cell that has a ? in the text of the cell. However when I do the Conditional Formatting, it is highlighting EVERY cell even when there is no ? in the cell.
Could you please advise?
ABCDE2908POL3362Westn Europn Pol Sys114911592909PAF9615Who Makes...
I'm having new problem with a macro that I have been using for several years. The macro allows me to import data from a prior year spreadsheet into the current version of the spreadsheet form. The problem is intermittent and only seems to occur in specific folders on my laptop.
MyFile =...
I created one combo box in my excel for search my customer name with Khmer Language. While i type Khmer inside they show up with Chinese Verb(as show in picture below).
But when i type Khmer outside of ComboBox, it working probably. and i copy it into still ok while the combobox still...
I'm trying to find any cells in my table that have the entry "???" but sadly VBA is just reading the ?s as wildcards. Is there any way to make it specifically find the characters? Thank you!
Tried to make the conditional format
=COUNTIF(AG2:AG1418,"?")
Of course the issue is that it adds up not only ?'s but also Y or N (the other two possible cell entries)
How can I make it just count the ?'s?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.