highlight font by date
-Hello,
Is there a way to highlight font and type for a cell by a date criteria? For instance, if a date is within 3 days of the current system date I want the date bolded in red 14pt font. I also want to use green and yellow colors to indicate other proximities of date to current system date. I think I might be able to use conditional formatting for this but not sure how. Thanks, Nelly |
highlight font by date
You can use conditional formatting and set the "formula" option to something
like this (where the value is in E12) =E12(TODAY()-3) Tim "Nelly" wrote in message ... -Hello, Is there a way to highlight font and type for a cell by a date criteria? For instance, if a date is within 3 days of the current system date I want the date bolded in red 14pt font. I also want to use green and yellow colors to indicate other proximities of date to current system date. I think I might be able to use conditional formatting for this but not sure how. Thanks, Nelly |
highlight font by date
On Apr 27, 9:12 am, Nelly wrote:
-Hello, Is there a way to highlight font and type for a cell by a date criteria? For instance, if a date is within 3 days of the current system date I want the date bolded in red 14pt font. I also want to use green and yellow colors to indicate other proximities of date to current system date. I think I might be able to use conditional formatting for this but not sure how. Thanks, Nelly Here's one possible way. Create a cell that has your system date. Let's say 4/27/07 is in A1. Then use two more cells, one to be 3 days above A1 and 3 days below A1. So, in A1 you have 4/27/07, in A2 you have =A1+3 (or 4/30/07), and in A3 you have =A1-3 (or 4/24/07). Then select the dates you want to compare to A2 and A3, go to Menu Bar: Format/Conditional Formatting..., and setup your condition. (i.e. Cell Value Is; between; A2; and A3; select the "Format..." button and select your "Font style:" and "Color:"). Note: You can add up to 3 conditions with conditional formatting. Matt |
All times are GMT +1. The time now is 04:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com