| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell color change without using conditional formatting
I have a multi-tab workbook with several checklists.
Once item on list is complete owner puts YES in status box and cell turns green. I have a combined list of all the tabs on another sheet. I need the combined list to pull the YES response from each individual checklist tab and also turn Green. Conditional formatting will not allow cross worksheet actions. Is there another way to pull all the YES data into the overall checklist? thanks Trese |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
