Hi Simon,

ISBLANK applies to a specific cell; not a range of cells. Need to count the
cells with data or count the blank cells.

Try the following. Note the absolute addressing for $A$1:$G$1 otherwise the
range will change for each cell in the range.

=COUNTA($A$1:$G$1)=0

You could also use =COUNTBLANK($A$1:$G$1)=7. However, not generic. If you
change the range then need to change the 7.


--
Regards,

OssieMac


"Simon" wrote:

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.