I've got a pretty simple spreadsheet.
I have three columns, Data is entered into the first 2 and the sum is returned in the third.
My codeUsing conditional formatting If data in B7 is greater than C7 the text is red. My trouble spot is that if B7 is greater than C7 I also need the text to be displayed inside parenthesis.![]()
=IF(SUM(B7-C7)<=0,C7-B7,B7-C7)
Bookmarks