Oops!
ISERROR instead of ISNA

"Bob Tarburton" wrote in message
...
for cell A1 in conditional formatting enter the following function
=ISNA(FIND("?",A1,1))=FALSE
probably a simpler formula on the way too.

"mango7" wrote in
message ...

I want to make all cells which contain a question mark to have a red
fill but the conditional formating options don't allow you to make an
"if a cell contains ? then" format.


--
mango7
------------------------------------------------------------------------
mango7's Profile:
http://www.excelforum.com/member.php...o&userid=29529
View this thread:
http://www.excelforum.com/showthread...hreadid=510245