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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
exclude cells from calculation if custom format
if you are just using worksheet formulas, then the have no cognizance of cell
color. (although you could write a UDF in VBA to return the value of the color index). If you are using code, just examine the cell for its interior.colorindex -- Regards, Tom Ogilvy "sandycity" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
exclude cells from calculation if custom format
Thanks Tom,
I was hoping that there was a way to do it on the worksheet, but I guess to have to try to put the calculations into code. "Tom Ogilvy" wrote: if you are just using worksheet formulas, then the have no cognizance of cell color. (although you could write a UDF in VBA to return the value of the color index). If you are using code, just examine the cell for its interior.colorindex -- Regards, Tom Ogilvy "sandycity" wrote: 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. |
Reply |
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 |