Login
or
Register
Subscriber & Member Login
Login, or register today to interact in our online community, comment on articles, receive our newsletter, manage your account online and more!
Login
Register
Home
»
Model Railroader
»
Forums
»
General Discussion (Model Railroader)
»
Inventory
Edit post
Edit your reply below.
Post Body
Enter your post below.
I use MS Excel, and one cool thing about it is the "Conditional Formatting" feature, as it allows me to set it so that the column for roadname formats differently for my Norfolk & Western locos than it does for others. For instance, if I type in "NW" as the reporting marks, then the cell formats with a black background, with white all-caps text, thus replicating the F6 NW paint scheme! For other roads, I can set up other conditional formats, which produce a cell with the right background color and text color. This makes it visually simple to locate my rolling stock by roadname; I could also do the same thing with other categories. <br /> <br />Excel is VERY versatile, and you can teach it to do all kinds of tricks. Of course, a pre-made database product would be more user-friendly, but once you reach its limits, you're done. If you teach yourself to use Excel (and maybe Access, I don't own this to know how it functions), you'll be constantly discovering more and better ways to use it.
Tags (Optional)
Tags are keywords that get attached to your post. They are used to categorize your submission and make it easier to search for. To add tags to your post type a tag into the box below and click the "Add Tag" button.
Add Tag
Update Reply
Subscriber & Member Login
Login, or register today to interact in our online community, comment on articles, receive our newsletter, manage your account online and more!
Login
Register
Users Online
There are no community member online
Search the Community
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
Model Railroader Newsletter
See all
Sign up for our FREE e-newsletter
and get model railroad news in your inbox!
Sign up