Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I want to create conditional formatting that will change the font color to
"red" and "bold" if the date is after the current date. The current date is always contained in cell A1. How do I do this using the conditional formatting option? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
If the current date is in A1 where have you entered the date that will be after
the current date? Assume =TODAY() in A1 and 11/23/2007 in B1 Select B1 and FormatCFCell Value is: greater than =$A$1 Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 21:24:00 -0700, MelB wrote: I want to create conditional formatting that will change the font color to "red" and "bold" if the date is after the current date. The current date is always contained in cell A1. How do I do this using the conditional formatting option? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |