Forum Discussion
ss2destiny
Nov 26, 2019Copper Contributor
Exel
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
1 Reply
- Gano1224Copper Contributor
Have you tried using "Highlight Cells Rules"??
It's on the Home Tab, under "Conditional Formatting"