Nov 26 2019 12:54 PM
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
Nov 28 2019 06:41 AM
Have you tried using "Highlight Cells Rules"??
It's on the Home Tab, under "Conditional Formatting"