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 currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names...
I have Excel 2003 (Office XP SP3) It seems to only let me Conditionally Format the Instant-Cell based on its Self-Same Contents. It also gives me the option of entering a Formula, but WHAT kind of formula would I use? Are there any Formulas I can use to get around this restriction?
To further...
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.