P

#### Pete

I'm currently working on some documents where I want to apply background color depending by a variety of conditions.

One example:

fill a whole row from e.g. A1:G100 where the cells C to G are empty

I managed to find a formula which gives me the right boolean result (T/F):

=AND(ISBLANK(INDIRECT("C"&ROW())),ISBLANK(INDIRECT("D"&ROW())),ISBLANK(INDIRECT("E"&ROW())), ... etc. ... )

Placing this formula somewhere outside my data range works perfect, but it just doesn't work with conditional formatting.

Am I doing something wrong? Maybe the settings?

regards

Pete