I have a spreadsheet that includes two currency columns. These columns(say Q and R) are derived from other columns based on my formula. Values would be null, positive or negative. How do I change entire row color based on combined value of Q+R? If Q+R is positive, entire row should be GREEN. If Q+R is negative, entire row should be RED. If both Q and R are null, no row color
