10-Marble

Solved

Color coded results

16 replies
9016 views
Translate All

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

Mathcad Usage

L

LucMeekesAnswer

23-Emerald V

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

The attached should work for you.

Success!
Luc

terryhendicott

21-Topaz II

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

19-Tanzanite

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.

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.

T

TH_10254372

Author

10-Marble

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

Translate

DJNewman

19-Tanzanite

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 q_check, 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.

1_conditional-formatting-with-excel-component.zip

R

Raiko

17-Peridot

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