Conditional Formatting.How is the cell highlighted? Manually? Conditional Formatting?
The yellow highlighted cell will be dynamic.Conditional Formatting.
So it would be extremely rare to have no value on one of the sides but i guess not impossible. I uploaded the condition.And what is the condition ? What happens if there are no values on one of the sides ?