Need help building a table

[Crumbs]

Hi everyone,

I have a problem with something I have to do with a table, and people told me that what I need is Microsoft Access. I'd like to hear from people here if that is true and more info:

I have a regular Excel table, with fields like "Name", "ID", etc. etc.
The thing is, there are values in the table that have to be updated every few months (different values - different times to update). For instance, I need to update all the values of Column X every six months. So what I do now in Excel is - I check the values once in a while, and if six months are up since the last update - I color the value-box in yellow so that I'll remember to update that value soon.

That's the basic thing - I need boxes colored when enough time has passed - telling me that I have to update them. I don't want to check this out every now and again, but that it will automatically color the box every some time.

If anyone could help me, I'd like to know what's the best program for this - Microsoft Access - or even if it's possible in Excel, etc.

Thanks a lot!
Jonathan

 

[FoFa]

Why not just use conditional formatting in Excel to do it?
Under FORMAT/Conditional Formatting for each data cell add this
=IF(DATEDIF($A12,TODAY(),"D")>=180,TRUE,FALSE)

Replace the A12 with your date field

 

[Crumbs]

Thanks a lot

Thank you very much