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? |
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? |
All times are GMT +1. The time now is 08:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com