I need to be able to count cells of a certain color in a couple different contexts. Essentially, I'm working to create a progress tracker of data previously entered into a registry. Much of this data is either inaccurate or missing entirely. I have colored cells that have inaccurate data the standard highlighter yellow color and cells that contain nothing are colored highlighter red. I would like to 1.) count a row if it contains any cell(s) that are colored yellow OR red and 2.) count the total number of yellow and red cells in a given rectangular range.
I'm fairly certain this is most effectively accomplished using a VBA coded function, however my experience in VBA is very limited and I'm having a hard time piecing together what I can find online to accomplish exactly what I need. In an ideal world, the best answer to this thread would contain 2 different VBA functions for each task with clear direction on what information to insert in a required field
I have attached a simplified example of what I am working with for clarity. I am happy to answer any questions that you may need answered.
Bookmarks