Hi Hector,

Neil here.
As for keeping things simple.... I'm trying too! Hehe.
As it turns out, each variable X, Y, and Z actually have different
inputed tolerances, thus I can't really make a general, simple
conditional format since it wouldn't apply to everything.

I will now try and make a new sheet and see if I can get the
formatconditions(1) statement to work. I think that's the best course
of action right now.

I'll post here if I find anything out. Otherwise, if I don't post, it
means I'm still stuck! lol

Since, Neil



On 7ÔÂ7ÈÕ, Îçáá2:07, "H¨¦ctor Miguel"
wrote:
hi, (...) ?

try using the same "condition" on with the format would by executed with "simple" functions (i.e.)

- count if any/all/which/... of the cells in your X,Y,Z columns are "in/out of your high/low range"

hth,
hector.