View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kaci kaci is offline
external usenet poster
 
Posts: 21
Default Conditional Formating

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a conditional
formating which can show "N/A" instead of #DIV in the worksheet. How can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.