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?

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.

Lastly, is there any books anyone could recommend on this level of work in
Excel?

Thanks!
--
Teri Albert