I need a formula to fill x amount of cells with a number or colour as i
enter x number into a spreadcheet.
what i am trying to do is a line rota.
where i put, for example, between 1200hrs & 1300 i need 6 people on, so
therefore would like 6 cells in a colum highlighted., if i change the 6 to a
3 then the highlighted cells would reduce to only 3.
I'm using excel 2003

many thanks and plse help!!