Sub: count the number of colored cells in excel sheet or otherwise count number of cells in increase or decreasing trend.
I have attached a excel worksheet showing the daily sales of six persons A to F. The cells are formatted in green and red colors to highlight the daily increase/decrease of trend in sales.
Now I require the following:
1) Formula to work out the No of days in rising trend from the last(latest)day
2) Formula to work out the No of days in declining trend from the last(latest)day
3) The formula may be drawn to count the number of red cells/green cells from the last(latest)cell OR otherwise by any other method and result exhibited as required as in answer sheet please.

In addition the %ge rise and decline from the last may also be worked out thro' a formula in separate columns.

Thanks in advance!!!
vks64

Hello vks64,

This site https://docs.microsoft.com/en-us/pre...olor-using-vba does exactly what you want. Follow the instructions.

Regards

Thanks sir