Hi
Try searching this group with "count cells with conditional color
formatting" or similar.
regards
Paul

On May 16, 5:11*pm, JAgger1 wrote:
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