Highlighting out of date cells
Closed
Ren
-
Aug 26, 2009 at 03:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 26, 2009 at 07:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 26, 2009 at 07:14 AM
Related:
- Highlighting out of date cells
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- The number of cells that contain numbers - Excel Forum
- If two cells match return value from third excel ✓ - Excel Forum
- If cell contains date then return value - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 26, 2009 at 07:14 AM
Aug 26, 2009 at 07:14 AM
In excel dates must be entred as month/date/year e.g. 8/12/09
not as you have done. Of course you can format it as you like
besides today's date is 26th August 2009
your data is in A1 to B3. If it is more rows the macro will work
try this macro
not as you have done. Of course you can format it as you like
besides today's date is 26th August 2009
your data is in A1 to B3. If it is more rows the macro will work
try this macro
Sub test() Dim rng As Range, c As Range Set rng = Range(Range("B1"), Range("B1").End(xlDown)) For Each c In rng If c <= Date - 14 Then c.Interior.ColorIndex = 3 Next End Sub