Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
distinguishing formula cells
I have a column where most cells are based on a formula; but from time
to time I would override selected cells with a plain number. Is there a way to automatically show (say with a shading) which cells in a column are based on formulas and which cells are directly entered numbers (the ability to do either one is sufficient, but I'd like to know how to do both) ? Thanks in advance - its amazing how much help one gets in this ng. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) |