My client has 20 staff cars. They want to show on a grid which cars out out and which are available. I had figured a grid system which is colour-coded (conditional formatting) but am struggling with the correct method.
I have a table for cars.
There's a Car ID field and a Car In Use field. Car ID is numeric, Car In Use is Yes/No.
I'd like to create a grid which shows say a square which is coloured red if 'Car ID=1, Car In Use=Yes'. There would be 20 boxes which would be on a 5 wide, 4 high pattern so I can't use a list format.
Any suggestions please?
Using FM14 Pro Adv, Mac OSX