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.