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!
|