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
- Based on the values in cells b77 b81 c77 - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Vim python syntax highlighting - Software Forum
- Why can't i see highlights of someone on instagram - Instagram 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
