It would be interesting to know why Microsoft was so incredibly stubborn to not allow to filter by colors / collect value of color in a cell.
I am very, very aware that this is the wrong way to do things, but users really prefer to take their list and color their wrong cells red and the correct cells in green instead of using a separate column for "status".
Of course a separate column with status then allows to have the 99999 different type of statuses that are created.. but is just clunkier.
And I know that you can now (after how many years?) filter by colors, what again is clunky if there are multiple colors, but you cannot get the cells color without custom VBA.
A simple "cellcolor()" formula would allow to make faster color filters.
It is very funny that every organization seems to have a "database" which is a list of stuff. And "big data" is when this list does not fit to Excel anymore.
I am very, very aware that this is the wrong way to do things, but users really prefer to take their list and color their wrong cells red and the correct cells in green instead of using a separate column for "status". Of course a separate column with status then allows to have the 99999 different type of statuses that are created.. but is just clunkier.
And I know that you can now (after how many years?) filter by colors, what again is clunky if there are multiple colors, but you cannot get the cells color without custom VBA.
A simple "cellcolor()" formula would allow to make faster color filters.
It is very funny that every organization seems to have a "database" which is a list of stuff. And "big data" is when this list does not fit to Excel anymore.