Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
related cells in same ecel workbook
at work when a process is complete I colour in the cell as a quick visual
reference, how do I get a related cell in the same work book to automatically fill with colour |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
related cells in same ecel workbook
Formulas retrieve values--not formats, so that's out.
There's no even that fires when you change the format of the cell. So you can't rely on that. You could use the worksheet_selectionchange event and format the related cell after the next selection change. Or maybe you could use a macro that colors both cells at once. Or if you're lucky, you could use format|Conditional formatting for both cells. doorman wrote: at work when a process is complete I colour in the cell as a quick visual reference, how do I get a related cell in the same work book to automatically fill with colour -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you add related cells in a sum? | Excel Discussion (Misc queries) | |||
Temporarily highlighting related cells | Excel Discussion (Misc queries) | |||
Count dollars in related cells | Excel Discussion (Misc queries) | |||
reference in another workbook related to the name of material | Excel Worksheet Functions | |||
Click events on Ecel Cells | Excel Discussion (Misc queries) |