Try the following...

1) Select your data

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=ISNA(A1)

4) Choose your format, in this case "White" for the color of your font

5) Click OK

Change the cell reference in the formula from A1 to the first cell in
the range of data you selected.

Hope this helps!

Todd Wrote:
I am using a formula that returns #N/A frequently and I am wondering
if
there is a way using conditional formatting or a different format
feature to
not have those returns show? All the #N/A make the worksheet look
cluttered.

TIA


Todd


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=276264