Trying to find a ? (question mark) in the text of a cell (Conditional Formatting)

psycoperl

Active Member
Joined
Oct 23, 2007
Messages
339
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
  3. Web
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?

Screen Shot 2021-03-24 at 10.34.10 AM1.png


X_1123.xlsx
ABCDE
2908POL3362Westn Europn Pol Sys11491159
2909PAF9615Who Makes Policy?12191219
2910HIS3340Wmn in Europe: Ancient-Mdrn12121212
2911MGT9971Women - Entreprl Ldr11491179
2912MGT4971Women And Entrprnshp11521172
2913HIS3650Women In America11491169
2914HIS3340Women In Eur Anc/Mod11591199
2915ENG3285Women In Film11791179
2916ENG3720Women In Literature11491172
2917ENG3720Women in Literature12021219
2918BLS3024Women of Color12091219
2919ANT3110Women, Culture, and Society11991219
2920SOC3110Women, Culture, and Society11991219
2921LAW4906Women, Law, & Policy11461192
sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C3:C3000Cell Valuecontains ""textYES
C3:C3000Cell Valuecontains "¿"textYES
C3:C3000Cell Valuecontains "'"textYES
C3:C3000Cell Valuecontains ")"textYES
C3:C3000Cell Valuecontains "("textYES
C3:C3000Cell Valuecontains "."textYES
C3:C3000Cell Valuecontains ","textYES
C3:C3000Cell Valuecontains "\"textYES
C3:C3000Cell Valuecontains "/"textYES
C3:C3000Cell Valuecontains ""textYES
C3:C3000Cell Valuecontains ":"textYES
C3:C3000Cell Valuecontains "&"textYES
C3:C3000Cell Valuecontains ""textNO
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

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.
Go back
Back
Top