Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i set up a formula?
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |