| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format on adjacent cells
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format, Color Scale adjacent cells | Excel Discussion (Misc queries) | |||
| conditional format of adjacent cell with different range and crite | New Users to Excel | |||
| Copying a range adjacent to Conditional Format - CF Rule adds to P | Excel Discussion (Misc queries) | |||
| Conditional sums for adjacent cells | Excel Worksheet Functions | |||
| conditional formatting adjacent cells | Excel Worksheet Functions | |||
Threaded Mode
