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 b88 ✓ - Excel Forum
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- Vim python syntax highlighting - Software Forum
- Excel formula for color of cell - Guide
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
