| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick text key to format 2 cells
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??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| QUICK FORMAT WITH APOSTROPHE | Excel Discussion (Misc queries) | |||
| Quick question on sheet format | Excel Discussion (Misc queries) | |||
| quick Conditional Format question <--rookie here | Excel Programming | |||
| format cells having text | Excel Discussion (Misc queries) | |||
| excel quick find format | Excel Worksheet Functions | |||
Threaded Mode
