elemenopee
New Member
- Joined
- Mar 16, 2017
- Messages
- 16
I want to highlight cells containing formulas based on the result of the formula not equalling zero.
Two columns
<colgroup><col width="249" style="width: 187pt; mso-width-source: userset; mso-width-alt: 9106;">
<col width="272" style="width: 204pt; mso-width-source: userset; mso-width-alt: 9947;">
<tbody>
</tbody>
Column J contains a VLookup formula.
I know I need to use a formula in conditional formatting, but can't get it working.
Any suggestions?
Two columns
Column I | Column J |
Account Name 1 | $0.00 |
Account Name 2 | $20.00 |
Account Name 3 | $0.00 |
Account Name 4 | ($10.00) |
Column J contains a VLookup formula.
I know I need to use a formula in conditional formatting, but can't get it working.
Any suggestions?
Last edited: