Highlighting "?" in a whole sheet.

[marlina]

I want to condtionally format my sheet so that cells containing ? would get highlights. But when i select highlights cells containing ? in the conditional formatting, Whole Sheet gets highlighted. I though maybe its Wild character and tried "?" & '?'. But Not working. Thanks in Advance.

 

[Joe4]

Do you mean cells that are EXACTLY equal to ?, or cells that contain ? anywhere in them (like "How are you?")?
If you are just checking for cells EXACTLY equal to ?, you can select your sheet, then choose the conditional formatting formula option, and use this formula:
=A1=CHAR(63)
and then choose your formatting color

 

[marlina]

Do you mean cells that are EXACTLY equal to ?, or cells that contain ? anywhere in them (like "How are you?")?
If you are just checking for cells EXACTLY equal to ?, you can select your sheet, then choose the conditional formatting formula option, and use this formula:
=A1=CHAR(63)
and then choose your formatting color

No, I am looking for cells that contains ?. Same as your example (like "How are you?")

 

[Joe4]

Use the "Format only cells that contain" rule type, choose the "Specific Text" option, with "containing", and then type ~? in the box, and choose your formatting color option.

 

[marlina]

Use the "Format only cells that contain" rule type, choose the "Specific Text" option, with "containing", and then type ~? in the box, and choose your formatting color option.

Working Perfectly