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? |
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? |
All times are GMT +1. The time now is 06:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com