Forum Discussion

ss2destiny's avatar
ss2destiny
Copper Contributor
Nov 26, 2019

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

  • Gano1224's avatar
    Gano1224
    Copper Contributor

    ss2destiny 

     

    Have you tried using "Highlight Cells Rules"??

     

    It's on the Home Tab, under "Conditional Formatting"