#N/A Conditional format?

[Stephen]

Hi Folks,

I'd like to setup a conditional format or a macro to run down my column A
that will highlight a given cell red or yellow if the result of the forumla
is #N/A.

Any ideas?

Thanks in Advance!

 

[ryguy7272]

http://www.contextures.com/xlCondFormat03.html#Errors

regards,
Ryan---

 

[Stephen]

good stuff.

Thanks a bunch.

Now the next step is to find all #N/A values in column A, then copy and
paste the values from that row in columns A & B and paste them somewhere else
for review by the user.