I got some help on this from MVP Niek Otten:
*********
On the Home tab, choose Conditional Formatting>Use a formula to determine
which cells to format>Format values where this formula
is true, fill in the formula, Format>Fill, choose a color
The formula might be something like
=NOT(ISERROR(FIND("?",A1)))
Do you answer the post?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
**********
--
Biff
Microsoft Excel MVP