Counting Cells of Specific Colors

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.

If you only use these two colors, then perhaps these two functions will suffice.

Please Login or Register  to view this content.

You can use them in your code, e.g.

Please Login or Register  to view this content.

but you can also call them like a sheet function, e.g.

Please Login or Register  to view this content.

Note that simply changing the color of the cell will NOT recalculate the function. You have to force the recalculation of the sheet with the F9 key.

Artik