View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen[_24_] Stephen[_24_] is offline
external usenet poster
 
Posts: 83
Default #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!