If Value is consecutive 15 times or more in the same column then highlight cells

[Ossian13]

Hi everyone,

i have an excel file and in a column i have two values, true or false. I want to highlight cells if the value true is consecutive 15 times or more. I think i can do this with conditional formatting but im not quite sure. Would you be so kind to tell me some suggestions?

Thank you and regards,
Ossian

 

[JoeMo]

1. Select the column (in this example it's A).
2. Home>Conditional Formatting>New Rule>Use a formula
3. Formula is: =COUNTIF(A1:A15,TRUE)=15
4. choose the format you want and press OK

 

[Ossian13]

Hi Joe,

thanks for your reply, in the meantime i managed to write a macro using offset. Thanks for your effort tough . Cheers!