#N/A Conditional format?
 

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!

#N/A Conditional format?
 

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

regards,
Ryan---

--
RyGuy


"Stephen" wrote:

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!

#N/A Conditional format?
 

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.

"Stephen" wrote:

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!