Skip to main content
P
ptc-42609121-Visitor
1-Visitor
November 7, 2011
Question

Change sheet color when certain limits are not met or exceeded

  • November 7, 2011
  • 2 replies
  • 3858 views

Hello,

i have somewhat of a big mathcadsheet. the Variables are at the top of the sheet, and the results are at the bottom of the sheet. To get to the bottom of the sheet, i have to scroll a lot to see if the results are okay or not. i have inserted many areas.

1) Is it possible to insert areas within one area in Mathcad14?

2) Is there anything in Mathcad14 that will possibly make the sheet color change if certain conditions ( results at the bottom of sheet) are not met . By doing this i know while i am still at the top of the sheet that the results at the bottom are not acceptable? or anyother idea that you could think of

Thanks to all helpers!!

2 replies

W
wayne12-Amethyst
12-Amethyst
November 7, 2011

You can create a hyperlink (or links) to jump to the end (or various sections), see help

P
ptc-42609121-VisitorAuthor
1-Visitor
November 8, 2011

Thanks Wayne!

i tagged the region at the bottom of the sheet as "Finalresults". At the top of the sheet where my variable is i am trying to create a link to the tagged region "Finalresults".what do you put in "Link to file or URL" since it is within the same sheet?

R
Raiko17-Peridot
17-Peridot
November 8, 2011

Hello Sam,

here's a sheet with a solution I'm using

Cheers

Raiko

P.S.

Forgot the file. Here it is in MC 15

M
MikeArmstrong1-Visitor
1-Visitor
November 8, 2011

Nice example Raiko, but there's no conditional statement where the colour changes.

Mike

R
Raiko17-Peridot
17-Peridot
November 8, 2011

Hello Mike

How so? The textbox changes colour on the evaluation of a computation result. If the result is less than 1 than it remains white otherwise it turns yellow.

Change b from 111 to 88 and you'll see.

Raiko

P.S.

There is still this glitch on the web-page that claims that an error occured whilst processing and if you resubmit you'll end up with tons of identical messages!!!

Terms & ConditionsAccessibility statement