Excell Sum calculation
Closed
Georgio
-
3 Nov 2009 à 20:13
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Nov 2009 à 22:05
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Nov 2009 à 22:05
Related:
- Excell Sum calculation
- Vat calculation excel - Guide
- Calculation is incomplete. recalculate before saving - Guide
- Electrical calculation software free download - Download - Calculators
- Excell mod apk - Download - Spreadsheets
- Mtu calculation - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
3 Nov 2009 à 22:05
3 Nov 2009 à 22:05
I presume the data is 12th march. in that case in my version and regional configuration it should be entered as 3/12/09.
it is entered in A!
right click the sheet tab and click view code and in the resulting window copy paste this EVENT CODE. whenever you activate this sheet this event code is invoked. If 6 months(180 days) are over then B11 will have entry "expired" and A1 will be in red.
it is entered in A!
right click the sheet tab and click view code and in the resulting window copy paste this EVENT CODE. whenever you activate this sheet this event code is invoked. If 6 months(180 days) are over then B11 will have entry "expired" and A1 will be in red.
Private Sub Worksheet_Activate()
Dim x As Integer
Range("A1").Interior.ColorIndex = xlNone
Range("B1").Clear
x = Date - Range("A1")
If x > 180 Then
Range("B1") = "expired"
Range("A1").Interior.ColorIndex = 3
End If
End Sub
