Hi Everyone,

I Am Having Trouble Turning A Complete Row From Default White To Different Colors Under Certain Conditions. As Per The Attached Worksheet, Which Will Be Of A Stock Portfolio, I Am Attempting To Turn The Row Red If Cell M9 Is A Negative Number. I Did A Conditional Format Using "Less Than 0" And Turned Only Cells With Negative Numbers Red. How Do I Turn All The Cells, Even The Ones With Dates, Text, Positive Numbers, Etc ? I Am Looking To Have Rows With Loosing Stocks Turn Red, Winning Stocks Turn Green, And Stocks Which Have Not Been Sold (Open Positions) Staying Default White. Thank You In Advance For Your Help, And Have A Great Day ! Steve

TestStocksFormulas.xlsx