View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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?