Number Of Cells Between Colored Cells?

  • Thread starter Thread starter JAgger1
  • Start date Start date
J

JAgger1

Using conditional formatting I'm able to highlight a cell with Red
when ever the number I'm searching for occurs in A1:A1000. Sometimes
the number will occur several times. Is there a way to count how many
cells there are between occurances of color? Thanks in advance
 
Hi
Try searching this group with "count cells with conditional color
formatting" or similar.
regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Macro to automatically go to the right of the last colored cell 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Cell Count Between Value 13
How to code macro for worksheet? 4
How to blank the colored cells? 0
Conditional Formatted Colored Cells 1
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top