I'm doing a shift roster for work, and want to be able to type in say "6",
and have the cell auto format to 6am, with the cell coloured yellow, and the
cell directly beneath to also be yellow with say "7.5". I need it in two
seperate cells as I need to total peoples hours.
I've know how to conditional format with the colour, but I also need to have
text in that cell and the one below.
Is this at all possible???