Count coloured Cells with text

[thesilkster]

Hi i am trying to count text within a spreadsheet but with 3 different colours

i have managed to count total cells with the text but this needs to broken down to 3 colours.

i do have some VBA that looks at the colours. please see below

any help is appreciated

thanks

 

[Luke M]

What is currently determining the color of the cell? Is it from a conditional format, is there a logic rule, or is it just whatever the user felt like coloring the cell?

 

[thesilkster]

What is currently determining the color of the cell? Is it from a conditional format, is there a logic rule, or is it just whatever the user felt like coloring the cell?

Hi Luke
No its a simple select if the check was good its green if it was minor its orange and if there was a safety related its red the colours are simply pasted in

thanks

 

[Luke M]

I would suggest that in the future you setup your tool to have a text/value somewhere that the color is based off of. Not only will it make future data analysis easier, but it lets people who are color-blind still have a chance to read and understand the file.

Nevertheless, it is possible. See that attached for mock-up with color counting. Functions arguments are:
CountCellColor(RangeToLookAt, CellWithColorToMatch, CellWithValueToMatch)

 

[thesilkster]

I would suggest that in the future you setup your tool to have a text/value somewhere that the color is based off of. Not only will it make future data analysis easier, but it lets people who are color-blind still have a chance to read and understand the file.

Nevertheless, it is possible. See that attached for mock-up with color counting. Functions arguments are:
CountCellColor(RangeToLookAt, CellWithColorToMatch, CellWithValueToMatch)

View attachment 23315

Thank you very much

this made it really easy to adapt thanks

Karma to you