Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |