count colored cells

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 /...

HI all! Admittedly, I'm terrible at Excel. I keep a spreadsheet for work and color code it. I found a formula via Google to count cells by color with a "key" I made to reference (i.e. I have a cell colored Yellow that said "Waiting for Verification") and then it counts how many are colored...

Hello! I need a formula which will return the number of rows meeting 2 criteria. My data set: column A has patient names (Last, First); column B has Date of Appointment (mm/dd/yyyy) How can I return the number of patients (to a dashboard) with last names A-G with appt date <30 days ago? I...

Hi All, I've been using the below macro to count the number of Red cells vs Green Cells. The macro is working fine and have shared it for reference, my issue is that in order to optimize my excel, I am trying to use Conditional formatting to color my cells (eg: Red/Green) rather than doing it...

Hello, I've been asked by my manager in work to see if I can adapt a spreadsheet to work out people's Bradford Factor (a way of monitoring people's sickness https://en.wikipedia.org/wiki/Bradford_Factor) At the moment, they are using a spreadsheet with people's names in column A (starting at...

Hi! I am a novice to excel macros, and my first time posting here, but have learned much over the last few months, in large part due to this site! Thanks for everyone's help. On the workbook I'm working on now, I have several macros that need to be run throughout the day to import new data...

Need to provide a count to the analyst: Number of NON-Colored Rows (these are our primaries) and we have to record it on an activity report. Looking for VBA that will start at ROW 5 and count downward any rows that have been highlighted.... Actually, the count could simply count any colored rows...

I have seen any tried many variations of VBA code to count coloured cells in excel - which work if the cells are manually coloured - however the cells in my requirement are coloured by conditional formatting - all options tried ignore the conditionally formatted cells....help anyone?

Hello, I've been searching to see if the question I'm about to ask has been solved but so far haven't found an answer. I thought I could use this: http://www.cpearson.com/excel/colors.aspx He says: NOTE: ActiveCondition may result in an inaccurate result if the following are true: You are...