count cell colour

  1. M

    Counting Conditionally Highlighted Cells

    I can't figure out how to count the number of cells that are highlighted in a conditionally formatted column in Excel 2013. I have read through and tried many of the VBA solutions on this site but none seem to work in my spreadsheet. Here's a general overview of the spreadsheet - Column A is...
  2. P

    Countbycolor in conditional formatted cells VBA?

    Hi guys, I've been working on a spreadsheet for some time now and looked through several forums and threads to find an answer, but cant find any at all. The sheet is more or less like a gantt-chart with activities down column A and duration/weeks along the rows
  3. R

    Highlight a number of cells based on a count not value

    Hello to all, I am truly stumped. I searched but couldn't come up with anything that works. I am trying to highlight a number of cells based on a count not values. In other words if A1 has a number 5. I would like A2:A6, next 5 cells, to automatically highlight. I would prefer something in VB...
  4. T

    re counting cell colour

    Hi All ive read the post but have a problem, the count works but not if the cells a coloured based on conditional formatting, is there a workaround for this thanks

Some videos you may like

This Week's Hot Topics