| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting
I have made a calendar and I would like to have the font color of the dates
that are older than today change using conditional formatting. How doI do this? OLaf |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting
Select all the date cells, say B2:M32, and use a formula of
=B2<TODAY() -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Olaf" wrote in message ... I have made a calendar and I would like to have the font color of the dates that are older than today change using conditional formatting. How doI do this? OLaf |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting
Hi Olaf
- select the cells (assume you start with A1 as upper left cell) - goto the conditional format dialog and enter the formula =A1<TODAY() - apply your format (change A1 if required to the upper left cell of your selection) -- Regards Frank Kabel Frankfurt, Germany Olaf wrote: I have made a calendar and I would like to have the font color of the dates that are older than today change using conditional formatting. How doI do this? OLaf |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting
thanks
"Frank Kabel" wrote in message ... Hi Olaf - select the cells (assume you start with A1 as upper left cell) - goto the conditional format dialog and enter the formula =A1<TODAY() - apply your format (change A1 if required to the upper left cell of your selection) -- Regards Frank Kabel Frankfurt, Germany Olaf wrote: I have made a calendar and I would like to have the font color of the dates that are older than today change using conditional formatting. How doI do this? OLaf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
