smartliving
New Member
- Joined
- Jun 23, 2015
- Messages
- 10
So I still haven't figured out an answer and I didn't want to bump my old post.
I have a set of data which is the percent change in closing prices of stocks for a bunch of stocks. I want to highlight a cell if the 10 proceeding dates add up to a total of +/- 3% or greater.
For example, if a stock's price had increased by .4 percent each day for 10 days, I want the cell to be highlighted because the total would be 4%. If a stock's price had decreased by .3 percent for 10 days, I'd also want to highlight the cell.
How in the world do I do this?
I have a set of data which is the percent change in closing prices of stocks for a bunch of stocks. I want to highlight a cell if the 10 proceeding dates add up to a total of +/- 3% or greater.
For example, if a stock's price had increased by .4 percent each day for 10 days, I want the cell to be highlighted because the total would be 4%. If a stock's price had decreased by .3 percent for 10 days, I'd also want to highlight the cell.
How in the world do I do this?