| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Of Cells Between Colored Cells?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number Of Cells Between Colored Cells?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate number of colored cells? | Excel Programming | |||
| Count the number of colored cells in a column | Excel Worksheet Functions | |||
| sum colored cells | Excel Discussion (Misc queries) | |||
| Is there a way to count the number of different colored cells? | Excel Worksheet Functions | |||
| Cell right next to colored cells is automatically colored on entering a value | Excel Programming | |||
Linear Mode
