himynameisphil

Hey Jim, you can definitely do what you want in excel using something called conditional formatting. Select column C. On the Home tab, in the Styles group, click "Conditional Formatting". Hover over "Highlight Cells Rules", and then click on the type of rule that you want to create ("Equal To..."). In the dialog box that appears, enter the value that you want to use for the rule (Y), and then select the formatting to be a green background. Do the same for N and a red background. Then for the DCC Address, a formula such as =IF(C2="N", "0", "") should work. and just drag it down as you usually would. Then set the conditional formatting for the orange colour. The steps might be slightly different depending on the version of Excel you are using, but hopefully points you in the right direction!

Thanks for the replies so far everyone! For those asking about Windows, the only thing he's got/is willing to use is a phone and an ipad, which is why a web-based application would be preferable I think. plus being able to take his own pictures/upload them straight to the catalogue etc. Doesn't seem like there's anything out there that is totally suitable, but I understand it's fairly niche! I'll keep an eye on this thread, but in the mean time put a few things in place to develop something bespoke for him. Thanks again for your responses.

Hello everyone! I've just signed up to ask if anyone can please recommend something to help my Dad catalogue his collection. We've tried Excel but he can't get to grips with it, so I'm looking for something a bit more user-friendly. I've been considering just building him a simple website that he can use on his phone, to first manually populate and update the collection over time, but then using it for things like quickly looking up certain models to see the functions etc. He doesn't have a Windows PC, so https://www.modeltraincatalogue.com/ is out of the question unfortunately. Would be great if something like this already exists, but if not, I might just bite the bullet and start developing it for him as a fun project we can work on together. Any advice would be greatly appreciated, thanks!