VBA to turn part of text in cell red if negative

[_eNVy_]

I have a column that the user wishes to have a simple calculation (H11-M11) as well as having a % in the same cell.

Formula is :::

=(H11-M11)&" / "&TEXT(H11/M11,"0%")

If the first part is negative, I wish for it to be RED.
If not, then GREEN.

Does someone know of a code that allows this?

Thank you.

 

[Joe4]

You don't need VBA. Just use Conditional Formatting, with a Conditional Formatting formula rule of:

=H11-M11<0