Re: conditional format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Trevor Shuttleworth (Trevor_at_Shucks.demon.co.uk)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 06:46:58 -0000

L.Peter

=AND(F5>TODAY(),F5<>"")

Regards

Trevor

"L.Peter" <Peter@nospam.local> wrote in message
news:etegsd1$DHA.3352@TK2MSFTNGP09.phx.gbl...
> Dear Group,
> how can i set the background color if a cell in a column if the follwing
> conditions are true:
> if the cell value > today() and the cell is not empty: change color to
> red
>
> at the moment, i can set it change color when cell value >today() but the
> problem is some time the cell value is " ", and because cell value has
> some white space so the color is changed (which is not desire), how can i
> check something like:
> if (len(trim(cel value))>0,red color, white color)
>
> TIA
>
> L.Peter
>
>

Quantcast