Use date modified to change format & create filter to track change

Use date modified to change format & create filter to track change

Post by UEFS » Fri, 17 Nov 2006 06:17:01


I have a spread sheet of which three columns contain 2006 medical insurance
election information and three susequent columns will contain 2007 medical
insurance election information. (Plan code, tier level & premium) If a
participant does not make a change during the open enrollment period, their
record remains the same, however if a change is made during the open
enrollment period, it must be reported to the carrier. Therefore I have
pre-populated these columns with the default values equal to the 2006
election information. I would like to know if there is a way to

1.) change the format of cells that are modified in the 2007 columns during
the open enrollment period
2.) create a "x" in another column that can be used to filter only the
changed records so they can be sent to the carrier with the change
information.

Thank you in advance for your help.
 
 
 

1. Turning Off tracking formatting changes using track changes

2. Date Created, Date Modified Changed to Date CD was burned

When I use the drag and drop method of writing a CD in
Windows XP home edition, all of the attributes relating to
date are either lost or changed to the date that the CD
was burned. I would like to keep all of the original
attributes of my photos.

Is there a preference or something I should change in XP
to allow me to keep the original attributes when writing
files to a CD? Or is there another method of burning CD's
in XP that I can use besides buying another software
product?

Thanks in advance,

Mark

3. track word changes ON while track formatting changes is OFF

4. Track change Author/Date popup shows US date format not correct regional set

5. Form Modified Date changes when the orderby property is changed

6. Date Modified changing without changes

7. Actual dates change when calendar changes or status date changes.

8. Access Form Modified date changes when nothing is changed

9. Track change pasting as text without change in format

10. Tracking Changes - Entering dates of changes

11. Track changes - accept formatting changes only?

12. Can I stop formatting changes from appearing in "track changes"?

13. How do I Never show Formatting changes in track change mode?

14. Changing track changes formatting

15. Can Word automatically date changes in Track Changes?