I want to highlight a cell as white (no fill) if the cell contains a number and the cell to the left of is blank - how can I achieve this using conditional formatting? Currently with my other rules, it will appear as red if the adjacent cell to the blank one contains a value.
I currently have 3 rules in this worksheet:
- Highlight red if d2>c2
- Highlight green if d2 < c2
- Highlight grey if blank
I currently have 3 rules in this worksheet:
- Highlight red if d2>c2
- Highlight green if d2 < c2
- Highlight grey if blank