max highlighting between 2 numbers

[Patcheen]

how do i highlight the max blank cells in column "F" between 2 numbers i assume i can do this with conditional formatting

 

[mikerickson]

Can you give us example of your data and what a "max blank cell" is?

 

[Patcheen]

Column "F4:F1000"
Row 4 7
Row 5 Blank
Row 6 Blank
Row 7 Blank
Row 8 3
Row 9 Blank
Row 10 Blank
Row 11 Blank
Row 12 Blank
Row 13 8

Result max blank (cells is 4 Row 9 to 12) so this would be highlighted

now dont forget that the "blank" cells have formula's in them

row 4,8 and 13 have numbers in them for this purpose -

Thank you for the help

 

[mikerickson]

So you have a column of formulas and what to know which series of cells that return "" is the longest blank series?
Is that the problem?

 

[Patcheen]

ya that is my understanding