1. Yes. However, there are some formats which only Excel 2007 can handle.
But when you save the file, Excel will tell you if you've done anything that
can't be supported in 2003. If you get that message, then fix those items.

2. You'll likely need to give an example to get a decent answer to this
question. How do you want a serial number (column C) compared to a date
(column G)?

Regards,
Fred

"hj" wrote in message
...
I have a few different dilemas going on here.
First: Can a conditional format be set up in Vista or Windows 7 both 64
bit,
and saved in 97-2003 excel saving the conditional formats?
Second: I have a spreadsheet column A is my received date, Column B is
Stock
#, Column C is Serial #, Column G is my finished date.
What I need to be able to do: When I enter information into Column C
(Serial
#), I need some type of notification if that same number has been entered
within a six month time period from my Column G (Finished date).