Hi,
first post: I need to analyze a serie of tests (F5:F1000).
Is it possible with conditional format to highlight in green the series of at least 5 consecutive "yes" and in red the series of at least 5 consecutive "No" ?
The range has no blank cells and contains "Yes" "No" "Nul".
A big thank you
Bookmarks