Are you using column G to control the data shown in other columns? This is
the only thing I can think that would cause the formatting not to fire, on
the basis that the only values in column G are X, I can't see why you would
filter G otherwise. I my question is correct, what column(s) is it
controlling?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"be_insane" <be_insane@yahoo.com> wrote in message
news:1130859801.695581.78780@f14g2000cwb.googlegroups.com...
> hum... don't seem to have had too much success with that. added in the
> formula but not getting any formatting.
>
> The filter is always on the same thing, Where X appears in a row. so
> its a grid system really.
>