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!

Conditional format
 

Luc, try this:
Select Column K, The choose "Formula Is" in the left combo box and paste this:
=AND(K1<TODAY(),L1<"Done")
Click "Format..."
Click the "Pattern" tab
Click the shade of red you want.
should be it click ok
--
Charles Chickering

"A good example is twice the value of good advice."


"Luc" wrote:

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!

Conditional format
 

1. Select Column K.
2. Format-Conditional Formatting
3. Condition1, select "Formula Is", then use this as the formula:

=IF($K1<TODAY(),IF($L1="DONE", TRUE, FALSE),FALSE)


If Column K is a date and time value, then use NOW() instead of TODAY().





"Luc" wrote:

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!

Conditional format
 

Correction:

=IF($K1<TODAY(),IF($L1<"DONE", TRUE, FALSE),FALSE)


"Vergel Adriano" wrote:


1. Select Column K.
2. Format-Conditional Formatting
3. Condition1, select "Formula Is", then use this as the formula:

=IF($K1<TODAY(),IF($L1="DONE", TRUE, FALSE),FALSE)


If Column K is a date and time value, then use NOW() instead of TODAY().





"Luc" wrote:

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!