S
Simon
Hi All,
what am I doing wrong??
I want cells A1 to G1 to conditionally format (to red) if they are ALL
empty, but if ANY one (or more) of them contain data (text) then NONE of them
should format.
I tried the formula =ISBLANK(A1:G1) then asigned a format, but for some
reason A1 only responds to the data in A1 and seems to ignore the rest of the
range, I've also tried similar range with formula ="" and cell value is equal
to "".
I am sure this must be possible but just can't find it.
I'v been at this for three weeks now. Please put me out of my missery!!
Please - no 'code' responses, 'CF' only. Thanks.
what am I doing wrong??
I want cells A1 to G1 to conditionally format (to red) if they are ALL
empty, but if ANY one (or more) of them contain data (text) then NONE of them
should format.
I tried the formula =ISBLANK(A1:G1) then asigned a format, but for some
reason A1 only responds to the data in A1 and seems to ignore the rest of the
range, I've also tried similar range with formula ="" and cell value is equal
to "".
I am sure this must be possible but just can't find it.
I'v been at this for three weeks now. Please put me out of my missery!!
Please - no 'code' responses, 'CF' only. Thanks.