Prev: Lookup reference help
Next: take name from the spreadsheet cell and get address from outlook
From: BoRed79 on 10 May 2010 03:53
Hi.

I want to set up some conditional formatting (in Excel 2003).

I want to turn certain cells either red (if any text appears) or green (if
the cell appears blank).

However, the cells have formulas in them to display information if it is
available in other cells. I cannot, however, make the conditional formatting
work - as I cannot use functions such as is/is not blank - as the cells still
contain formulas - so whilst they are not displaying inforamtion there is
still information in the cells which the conditional formatting is picking up.

Does anyone know if there is a function that allows you to use conditional
formatting based on what is displayed in a cell, rather than it formula
contents - or is there another workaround??

Thanks.

Liz.
From: Bob Phillips on 10 May 2010 04:00
Liz,

Try a formula of

=LEN(A2)=0

--

HTH

Bob

"BoRed79" <BoRed79(a)discussions.microsoft.com> wrote in message
news:9E04A9B9-13CB-4E55-A369-3C96A84F65AE(a)microsoft.com...
> Hi.
>
> I want to set up some conditional formatting (in Excel 2003).
>
> I want to turn certain cells either red (if any text appears) or green (if
> the cell appears blank).
>
> However, the cells have formulas in them to display information if it is
> available in other cells. I cannot, however, make the conditional
> formatting
> work - as I cannot use functions such as is/is not blank - as the cells
> still
> contain formulas - so whilst they are not displaying inforamtion there is
> still information in the cells which the conditional formatting is picking
> up.
>
> Does anyone know if there is a function that allows you to use conditional
> formatting based on what is displayed in a cell, rather than it formula
> contents - or is there another workaround??
>
> Thanks.
>
> Liz.


 | 
Pages: 1
Prev: Lookup reference help
Next: take name from the spreadsheet cell and get address from outlook