Hi guys,
Right now, I have an excel spreadsheet which displays the progress of the project by the cell colour(namely blue and red).
Does excel allow me to write a macro to calculate the total number of blue and the total number of red cells?
Thanks
Hi guys,
Right now, I have an excel spreadsheet which displays the progress of the project by the cell colour(namely blue and red).
Does excel allow me to write a macro to calculate the total number of blue and the total number of red cells?
Thanks
Re: Sorting by colour
How are You colouring the cells Fill Colour of Conditinal formatting?
Your subject title says 'sort' maybe this should be edited to count by colour
jiuk
Re: Sorting by colour
Just thinking our very own Dave Hawley has covered this very well click here for link and there is lots of extra information You might find extreamly helpful
jiuk
Don’t have an account yet? Register yourself now and be a part of our community!