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???

Use conditional formating. In the second cell below use "fromula is" instead
of "cell value is". In the formula reference the first cell address.

If A5 is the first cell the in A6
=if(A6 3,true,false) and add the formatting.

"Lizzibelle" wrote:

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???