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

Color coded results

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

 

 

LucMeekesAnswer
23-Emerald IV
March 20, 2023

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

The attached should work for you.

 

Success!
Luc

View in thread

16 replies

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

Translate
    DJNewman
    DJNewman19-Tanzanite
    19-Tanzanite
    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

     

    Translate
    PTC Marketer for Creo and Mathcad. I run their YouTube channels, some Creo campaigns, and all Mathcad campaigns and communications.
      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

       

      Translate
      DJNewman
      DJNewman19-Tanzanite
      19-Tanzanite
      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.

      Translate
      PTC Marketer for Creo and Mathcad. I run their YouTube channels, some Creo campaigns, and all Mathcad campaigns and communications.
        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.

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

          Without EXCEL Component.

          image.png

          image.png

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

            Thank you a lot

            Translate
            Terms & ConditionsAccessibility statement