| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Macro
I am using excel for our trucking dispatch department. Is it possible to
have a table of drivers so that when a driver is assigned to a job, the same driver listed in the table changes color? |
|
#2
|
|||
|
|||
|
You may be able to use Format|Conditional Formatting to achieve the same result
without a macro. Roger wrote: I am using excel for our trucking dispatch department. Is it possible to have a table of drivers so that when a driver is assigned to a job, the same driver listed in the table changes color? -- Dave Peterson |
|
#3
|
|||
|
|||
|
Roger
Macro not required. Check out FormatConditional Formatting. Gord Dibben Excel MVP On Thu, 28 Jul 2005 12:06:12 -0700, "Roger" wrote: I am using excel for our trucking dispatch department. Is it possible to have a table of drivers so that when a driver is assigned to a job, the same driver listed in the table changes color? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Hybrid Mode
