"tralbert" wrote in message
...
While I'm not new to Excel, I am new to using conditional formatting,
functions and macros within Excel. I'm working on a sheet that tracks
certain
data on new hires. We track this data for 3 consecutive 30 day periods. I
want to create two macros that will make things easier for me to report
data
in this worksheet.

One of the macros I would like to put in is any time I put in a new hire's
info it will go ahead and create a new line with all of the appropriate
formatting for each column (several of the columns will have conditional
formatting). This would be similar to how a new line is created in an
Access
table when you input a new record. Any suggestions?


What formatting, where?

The next macro deals sort of with hiding data/removing formatting. One of
the specific items being tracked is a new hire's retention/turnover
(meaning
if they quit or not). In each 30 day period of data, there is a column
that
is marked "Y" or "N" for turnover (Y means they stayed, N means they
quit). I
need to write a macro that looks at the turnover columns in the first and
second 30 days, and if there is a "N" input into either of them, then all
of
the conditional formatting is removed from that row, and the cells in the
row
(i.e. A25:U25) is marked in dark grey. I'm not sure how to go about doing
that. Any help would be appreciated.

Where is the Y/N columns?