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
 
Back
Top