Reply to thread

Message: [QUOTE="Simon, post: 3856668"] 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. [/QUOTE]