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.

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.

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.