I have a spreadsheet in excel 2003 where a range of cells contain different
text.

If there is no text in any of the cells within the range I would like the
range conditionally formated (red), however if any or all of the cells within
the range contain text then no format should be applied;e.g.

If A1 to D1 are blank format cells red, when text is entered into B1 remove
formatting.

All help greatly recieved.
Simon.