| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cells
Hey guys and gals this should be a simple problem i just cannot work it out! In A2 i have a Name i.e James In B2 i have a start time i.e 07:30 In C2 i have a finish time i.e 16:00 In E1 to AN1 i have times ranging from 06:00 to 23:30 What i need is the following: The cells in E2 to AN1 to be shaded from the B2 start time to the C2 finish time like i say this doesn't sound to difficult and and i am sure there is a very easy way to do it but i just can work it out cheers James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=503689 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an Excel function to shade cells? | Excel Worksheet Functions | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
