At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
go google and type in --manual for excel version (what ever it is ) and down load the pdf file
go to a book shop and buy a Excel for dummies book
or e-bay and excel for dummies or other excel explained books
explaining it as a reply will be as confusing as the reply would be pages long
If you are referring to the excel program, it is not possible to do that. You cannot make it change colours based on values in the cells. You would have to manually change the colours. Hope this helps. Cheers.
for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...
cell A3......(properties set as General to show digits)................ =SUM(A2-A1)
Hi,
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :
first change the settings in ControlPanel/Regional and Language Options. Click on Customize button/open the Date Tab and set the date format there. and then proceed with CSV. Open CSV in Excel and divide Text to coloumns. Ur all Date Cells will be in particual Format. and Select that coloumns and right click Format Celss....etc. Thanking u.
If u found any Douts, Suggestions ,Plzz let me know.
Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.
Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.
×