Hello! Requesting help for Conditional Formatting. Example in table below shows desired results. CAPITAL ONE is paid off in bottom table. When excel sees the a value higher than zero in the PAYOFF AMOUNT column I want the CREDITOR and PAYOFF AMOUNT cells to display with a red font.
<tbody>
</tbody>
Current Looks like this | ||||
Creditor | Present Balance | Present Payment | Payoff Amount | Future Payment |
Capital One | 1000 | 15 | 1000 | 0 |
Capital One | 1000 | 15 | 0 | 15 |
Want this to happen with conditional formatting | ||||
Creditor | Present Balance | Present Payment | Payoff Amount | Future Payment |
Capital One | 1000 | 15 | 1000 | 0 |
Capital One | 1000 | 15 | 0 | 15 |
<tbody>
</tbody>
Thank you!