View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc Luc is offline
external usenet poster
 
Posts: 23
Default Conditional format

I want do do the following :

The cells in column K contain a date
The cells in column L contain text.

If the date in column K < now() and column L does NOT contain 'DONE' then
column K should be RED( the background)


With column i mean a cell in this column

Who can help ?

Luc

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
339 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!