| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Font Color on Dates
Hi Everyone...
I need some help please... Can I make this worK? If on A1 is the current date and on B1 is the due date, can B1 change font color to red if it is less than a month from now? I am making a reminder or tracking sheet and I need to be informed if the due date is less than a month away...Thank you for your help.. -- Stacey |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Font Color on Dates
Hi Stacey
Select the range of cell in column B FormatConditional FormattingFormula Is =B1-A1<date(year(a1),Month(a1)+1,day(a1)) FormatFontRed -- Regards Roger Govier "Stacey1016" wrote in message ... Hi Everyone... I need some help please... Can I make this worK? If on A1 is the current date and on B1 is the due date, can B1 change font color to red if it is less than a month from now? I am making a reminder or tracking sheet and I need to be informed if the due date is less than a month away...Thank you for your help.. -- Stacey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
| Change in font and color | New Users to Excel | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Linear Mode
