Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Linked with flags
I have a main worksheet where all the info is inputted and then populated
into several other linked worksheets. I would like to have the main worksheet have a "red flag" when a certain column of information goes to low. example: if contribution magin drops below 10k, I would like the poplulated worksheets to show this number in red. Could you tell me how to do this so if someone else inputs into the main worksheet it is already done for them? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Linked with flags
Links only pass values, not formatting. You can add conditional formatting to
the linked cells in the poplulated worksheets to highlight them if their values meet the conditions you specify (ie, highlight in red if the cell's value drops below 10000). Hope this helps, Hutch "MayJuneJuly" wrote: I have a main worksheet where all the info is inputted and then populated into several other linked worksheets. I would like to have the main worksheet have a "red flag" when a certain column of information goes to low. example: if contribution magin drops below 10k, I would like the poplulated worksheets to show this number in red. Could you tell me how to do this so if someone else inputs into the main worksheet it is already done for them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel flags cells | Excel Discussion (Misc queries) | |||
Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
Date of worksheet comes out numbers on other linked worksheet | Excel Worksheet Functions | |||
How to get =MIN() given flags? | Excel Worksheet Functions | |||
Returning Flags from Solver used in VBA | Excel Programming |