conditional formatting

on a amotization sheet that may run to 240 payments, payments may start in any month and the first payment would be in about row 40 or so. want to highlight the december payment, which records the total interest paid for the year. then each december.

have tried inserted a col for month and can highlight the number 12 reperesenting december but want to highlight the entire row, when painting this format, i lose the orignal formating, when all i want to do is add color.

Hi Reno,

Assuming that your dates are entered in Column A, try the following:

1) Select your range of data you want to format
2) Format Conditional Formatting
3) Formula Is: =MONTH($A1)=12
4) Click OK

Hope this helps!

In article ,
"reno" wrote:

on a amotization sheet that may run to 240 payments, payments may start in
any month and the first payment would be in about row 40 or so. want to
highlight the december payment, which records the total interest paid for the
year. then each december.

have tried inserted a col for month and can highlight the number 12
reperesenting december but want to highlight the entire row, when painting
this format, i lose the orignal formating, when all i want to do is add
color.