Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In XLS, if a cell value is changed after a fixed date can the font color be
directed to change in order to indicate this. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Right-click on the sheet tab to display VBA code for the sheet. Then
paste the following code and change the range of cells and the date as needed. Private Sub Worksheet_Change(ByVal Target As Range) Dim MonitoredRange As Range Dim LimitDate As Date Dim inter As Range Set MonitoredRange = Range("A1") 'You can change this to an array, e.g. Range("A1:A10") LimitDate = "11/15/2005" Set inter = Application.Intersect(MonitoredRange, Target) If (Not inter Is Nothing) And (Now Int(LimitDate)) Then Target.Font.ColorIndex = 3 End If End Sub HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
Change cell to red when date in other cell is red | Excel Discussion (Misc queries) | |||
extract name when a date in another cell gets near | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |