Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formating is greyed out and unavailable | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) |