| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exclude cells from calculation if custom format
Have column of calculated figures, some of which have manually set custom
format to a different colour. How can I NOT include these when doing further calculations, eg. am searching array using vlookup and if statments but if result is cell with custom colour want to give warning message. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude Cell from Calculation | Excel Discussion (Misc queries) | |||
| How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
| Exclude non-numeric data from calculation | Excel Worksheet Functions | |||
| calculation to exclude weekends | Excel Worksheet Functions | |||
| Exclude cells from calculation? | Excel Programming | |||
Threaded Mode
