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
- How would you change all cells containing the word pass to green - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - 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
