Search : in
By :

Excell Sum calculation

Last answer on Nov 4, 2009 3:05:24 am GMT Georgio, on Nov 4, 2009 1:13:29 am GMT 
 Report this message to moderators

Hello,
I'd like to find out how to make an excell sum to highlight when a point in time has passed.
For example. say I buy a tin of beans on 12/3/09, if i input that date, I want a sum that highlights that it goes out of date in six months and tells me that date.also i want it to turn red if has passed that date.

Can anyone help

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Excell Sum calculation » in :
Calculate the power of your Power supply ShowCalculate the power of your Power supply Choosing the right power supply Links Choosing the right power supply When building up your PC it is quite difficult to determine the power supply to be used( this will depend on the...
Excel – Formula for cell calculation ShowExcel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download The Love Calculator ShowLove is a big word, then all means are good to find it. The name of each can say about it on compatibility between two persons a lot. The Love Calculator is a program which counting affinity between two individuals. It is not a precise science,...
Download N1bus Calculator Show
Download Advanced IP Calculator Show
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Calc - calc.exe Showcalc - calc.exe The process calc.exe corresponds to Windows' Calculator application. The file that corresponds to this process is normally found in the directory "%SystemRoot%\system32\calc.exe" (where %systemroot% is usually C:\WINDOWS.) It is an...
Computer - History ShowThe history of the computer owes its existence to the fact that people, who are lazy by nature, have always sought to improve their ability to calculate, in order to reduce errors and save time. Origins: The abacus The "abacus" was invented in the...
Ask your question Reply

1

 venkat1926, on Nov 4, 2009 3:05:24 am GMT

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. 

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

   
Reply to venkat1926
Ask your question Reply
They need your help