ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet Linked with flags (https://www.excelbanter.com/excel-programming/413338-worksheet-linked-flags.html)

MayJuneJuly

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?

Tom Hutchins

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