psycoperl
Active Member
- Joined
- Oct 23, 2007
- Messages
- 339
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
- 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?
Could you please advise?
X_1123.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2908 | POL | 3362 | Westn Europn Pol Sys | 1149 | 1159 | ||
2909 | PAF | 9615 | Who Makes Policy? | 1219 | 1219 | ||
2910 | HIS | 3340 | Wmn in Europe: Ancient-Mdrn | 1212 | 1212 | ||
2911 | MGT | 9971 | Women - Entreprl Ldr | 1149 | 1179 | ||
2912 | MGT | 4971 | Women And Entrprnshp | 1152 | 1172 | ||
2913 | HIS | 3650 | Women In America | 1149 | 1169 | ||
2914 | HIS | 3340 | Women In Eur Anc/Mod | 1159 | 1199 | ||
2915 | ENG | 3285 | Women In Film | 1179 | 1179 | ||
2916 | ENG | 3720 | Women In Literature | 1149 | 1172 | ||
2917 | ENG | 3720 | Women in Literature | 1202 | 1219 | ||
2918 | BLS | 3024 | Women of Color | 1209 | 1219 | ||
2919 | ANT | 3110 | Women, Culture, and Society | 1199 | 1219 | ||
2920 | SOC | 3110 | Women, Culture, and Society | 1199 | 1219 | ||
2921 | LAW | 4906 | Women, Law, & Policy | 1146 | 1192 | ||
sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
C3:C3000 | Cell Value | contains "" | text | YES |
C3:C3000 | Cell Value | contains "¿" | text | YES |
C3:C3000 | Cell Value | contains "'" | text | YES |
C3:C3000 | Cell Value | contains ")" | text | YES |
C3:C3000 | Cell Value | contains "(" | text | YES |
C3:C3000 | Cell Value | contains "." | text | YES |
C3:C3000 | Cell Value | contains "," | text | YES |
C3:C3000 | Cell Value | contains "\" | text | YES |
C3:C3000 | Cell Value | contains "/" | text | YES |
C3:C3000 | Cell Value | contains "" | text | YES |
C3:C3000 | Cell Value | contains ":" | text | YES |
C3:C3000 | Cell Value | contains "&" | text | YES |
C3:C3000 | Cell Value | contains "" | text | NO |