Count Conditionally Formatted Colour in Table

_eNVy_

Board Regular
Joined
Feb 9, 2018
Messages
53
Office Version
  1. 365
Platform
  1. Windows
Is there any way to create a function in VBA that will count all red coloured cells in a Table?

My table, named Input has 11 columns and starts at cell A6 (A6 being the first column header). See attached screenshot.

Above columns, ID / Date of Birth / Delivery mechanism / Review reason / Significant event / Outcome, I would like a count of all the conditionally formatted red cells.

Not sure if it is important, but according to the More Colours section when choosing a colour within the Format.., Red : 255 / Green : 0 / Blue : 0 and the Hex code is #FF0000.

The purpose is to highlight and count the number of missing data.

Thank you in advance!
 

Attachments

  • Example tbl.png
    Example tbl.png
    20.5 KB · Views: 9

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,186,312
Messages
5,957,137
Members
438,289
Latest member
donnabee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top