#N/A Conditional format?

  • Thread starter Thread starter Stephen
  • Start date Start date
S

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!
 
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.
 
Back
Top