| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Conditional Formatting
I want to change the background color of cells where the cell date is less
than or equal to the current date. How do I put in the current date in the formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003: Conditional Formatting
Using the function TODAY()
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I want to change the background color of cells where the cell date is less than or equal to the current date. How do I put in the current date in the formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003: Conditional Formatting
So what do I put in the brackets? I guess I type in
TODAY( ) But what do I put in the brackets? "Bernard Liengme" wrote: Using the function TODAY() best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I want to change the background color of cells where the cell date is less than or equal to the current date. How do I put in the current date in the formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003: Conditional Formatting
Nothing
=TODAY() will return current date. =NOW() will return current time. Gord Dibben MS Excel MVP On Wed, 20 Sep 2006 11:16:01 -0700, oceanmist wrote: So what do I put in the brackets? I guess I type in TODAY( ) But what do I put in the brackets? "Bernard Liengme" wrote: Using the function TODAY() best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I want to change the background color of cells where the cell date is less than or equal to the current date. How do I put in the current date in the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 specifications for conditional formatting in Excel | Excel Discussion (Misc queries) | |||
| Formatting on imported data (Excel 2003) | Excel Discussion (Misc queries) | |||
| Why do conditional formats appear by themselves in Excel 2003? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel: Additional Conditional Formatting | Excel Worksheet Functions | |||
Hybrid Mode
