afgavinstan wrote:Bike was too wee. The guy selling it was reaching when he said "gents". Cunt was 5ftFuckall.
acemuzzy wrote:For the drop down you want data validation, choose from a list (which you either type in, or choose from a set of cells if you have "high"/"low"/"blah" in cells)
For the colouring, you need conditional formatting. There's a wizard, but you'll need to be a bit careful to get the whole row referencing the right column.
Not sure we have a thread, but there have been multiple Excel questions over the year so it may be no bad thing!
MattyJ wrote:I think I need to create a table on a separate sheet and point it at it? When you don't do something for like 8 months it's so easy to forget
It looks like you're new here. If you want to get involved, click one of these buttons!