You can try using forms in datasheet mode and conditional formating. You can also keep Excel as the interface and use Access as a data store (personally I would prefer SQL Server as a data store), and perhaps build a 3-tier model: [SQL Server] --> [Access] --> [Excel] or [Access] --> [Access] --> [Excel].
Would there be anyway to shade the Odd Event # (Row B) and Not the Even Event#?
How would one go about doing that? Sounds like what you mentioned as far as "conditional formatting" but I have no experience doing that. Can you point me in the right direction as far as figuring out how to do that?
I was able to figure out that part. What I am unable to figure out though, is how to create one based on whether or not a number in a ____ is an odd or even number and to shade that entire row a different color based on that.
1. New Rule for Event #.
(Check values in the current record or use an expression) I'm guessing to use that one, not the compare to other records? unless it's compare against other records in the same column.)
Now the part that I'm stuck on is where to go from there?
It fives an option to Format only cells... but I've been digging in every bit of it, and I can't find anything that mentions odd/even, and if I did, then how do I go about telling it to change the shade of that entire line to a darker gray?