I am working on a spreadsheet where I am dealing with different medicines. I
have one column set up where it subtracts the actual cost from how much the
insurance pays. When the number is negative I have the cell formatted where
it becomes red with parenthesis.

My question is how can I set it up where the medicine also becomes red, when
the amount is a negative number besides manually making it red? Almost like
conditional formatting, but there is no condition. If the amount is red, I
want the medicine to reflect that as well.