I have compiled price data for say 50 stocks over time. I want to compare the price today with the price of the same stock say 5 days previously. If the price is greater, I want to color it green, if lower red, and if no change yellow. I have tried conditional formatting but could not get it to work. Recommendation please.
Bookmarks