Skip to main content
T
TH_1025437210-Marble
10-Marble
March 17, 2023
Solved

Color coded results

  • March 17, 2023
  • 4 replies
  • 8668 views

How do I get Mathcad Prime to give me colored coded results. If the result is Pass, return color in Green and if fails, Red? Please help

 

 

Best answer by LucMeekes

Indeed, that "conditional.....-prime-8.mcdx" file is a Prime 9 file.

The attached should work for you.

 

Success!
Luc

4 replies

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
March 17, 2023

Hi,

Color coding of results can only be done manually using the math formatting tools.

Others have made the same request for automatic coloring..

Cheers

Terry

    DJNewman
    DJNewman18-Opal
    18-Opal
    March 17, 2023

    As of Mathcad Prime 9, there's no direct way to do this, but one workaround involves putting the results in an Excel Component as an Input Expression, and use Conditional Formatting there.

     

    DJNewman_0-1679081072043.png

     

    DJNewman_1-1679081104993.png


    I recommend voting up this Idea: https://community.ptc.com/t5/Mathcad-Ideas/Conditional-formatting-of-outputs/idi-p/736333

     

    PTC Marketer Creo and Mathcad. I run their YouTube channels, some Creo campaigns, and all Mathcad campaigns and communications.
      T
      TH_1025437210-MarbleAuthor
      10-Marble
      March 20, 2023

      Hi Thanks a lot. This is what I need to do. Unfortunately I am new to mathcad so I struggled to do what you said but didn't figure it out. I understand your response is if you have the data on a excel sheet. 

      I was hoping to just format the sheet to give me response based on info on the same sheet.

      For example: My sheet has "q(allowable)" , and I find "q", how do I make the sheet to give me green if OK and red if Not OK. Please do a step or uplaod a mathcad sheet where you did it. Thank you

      TH_10254372_0-1679328806434.png

       

      DJNewman
      DJNewman18-Opal
      18-Opal
      March 20, 2023

      Attached a worksheet!

       

      See if that helps and if you can figure out the rest on your own! I don't know the math behind q and the maximum allowable q so I just defined those as variables (and a combo box for fun), but you can replace those with whatever and it should work.

       

      You can press the - by the Excel Component's input expression to hide it. The magic is that Excel Component input expression being equal, in this case, to qcheck, and if you double-click the Excel Component to open Excel, setting Excel's Conditional Formatting rules to activate upon "OK" or "Not OK" values.

      PTC Marketer Creo and Mathcad. I run their YouTube channels, some Creo campaigns, and all Mathcad campaigns and communications.
        R
        Raiko17-Peridot
        17-Peridot
        March 21, 2023

        It would be great if you'd add your request to the feature suggestions. This is something I'm desperately hoping for since I do have to check calculation documents of 40+ pages length. 

        Any result highlighting, aka. conditional formatting, in MC  prime would be welcome.

          ttokoro
          21-Topaz I
          ttokoro21-Topaz I
          21-Topaz I
          March 22, 2023

          Without EXCEL Component.

          image.png

          image.png

          t.t.
            T
            TH_1025437210-MarbleAuthor
            10-Marble
            March 22, 2023

            Thank you a lot

            Terms & ConditionsCookie settingsAccessibility statement