How to add a hyperlink column to asp.net datagrid - where only one value is a hyperlink

[Dave]

I have a column which has either "Yes" or "No" as the data - I want only the
"No"'s values to be a Hyperlink -

Clicking "No" would then take then to hyperlink - along with member's
membership ID (which is another column in the datagrid).

Hyperlink = ../Cardio.aspx?OMEMBID={0}

Any assistance would be nice.

thanks

Dave