Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAR PAR is offline
external usenet poster
 
Posts: 20
Default Use date modified to change format & create filter to track change

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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change date format from dd/mm/yyyy to mm/yyyy flow23 Excel Discussion (Misc queries) 3 April 4th 23 11:26 AM
How do i change the format of a 2 digit date BB Setting up and Configuration of Excel 1 September 17th 06 09:31 PM
Change date format from US to English (Australian) altona Excel Discussion (Misc queries) 3 May 5th 06 03:11 AM
Date Format Problems?? nastech Excel Discussion (Misc queries) 5 November 14th 05 02:53 AM
Can I change a date with no format (20051111) to date format? Rose New Users to Excel 2 November 11th 05 10:03 PM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"