Ahhh, thanks Bob. My problem was I was using Cell Value Is instead of
Formula Is.

:)

On Jan 6, 2:01*pm, "Bob Phillips" wrote:
Select R1:Rn and use a CF formula of

=ISERROR(R1)

--
__________________________________
HTH

Bob

"Sandusky" wrote in message

...

Excel 2003 SP3
Windows XP Pro SP3

If possible, I'd like to use conditional formatting to shade any cell
in Column R in which the formula in that cell returns an error. *Can
this be done?