Highlighting out of date cells
Closed
Ren
-
26 Aug 2009 à 03:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Aug 2009 à 07:14
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Aug 2009 à 07:14
Related:
- Highlighting out of date cells
- How to delete cells in word - Guide
- Excel arrow keys not moving cells - Guide
- Vim python syntax highlighting - Software Forum
- "Cells(1, "a")" "type mismatch" ✓ - Excel Forum
- Arrow keys scrolling in Excel ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
26 Aug 2009 à 07:14
26 Aug 2009 à 07:14
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
