Conditional format formula

[Brew]

In range da20:da106, I have records in each cell with either -450 or 900 value. How do I create a conditional format formula to identify each cell within this range that has a record of 900, which immediately follows 2 or more consecutive -450 records in the range?

Example
Da20=900
Da21=-450
Da22=-450
Da23=-450
Da24=900
Da25=-450
Da26=-450
Da27=900
Da28=900
In this example, only da24 and da27 meet the condition

 

[jindon]

Yup! your right and how didi it go?

 

[Brew]

amazingly, it did not work

 

[jindon]

amazingly, it did not work

Bad luck!

 

[Peter_SSs]

Brew

Can you spell out exactly what the first condition in your Conditional Formatting is and how it formats the cell when that 1st condition is met?