| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formating #VALUE! cells
I have a few formulas in a spreadsheet that are equal to #VALUE! which is
accurate, but is making my spreadsheet sloppy to read. Is there a way to format cells to display a specific value if the cell value = #VALUE!. For example, if cell W10=#VALUE! then display "TRUE" in the cell (instead of #VALUE!). Thank you. Regards, Diane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help adding text values | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
| HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS. | Excel Discussion (Misc queries) | |||
| formating text cells | Excel Discussion (Misc queries) | |||
Threaded Mode
