Conditional formatting

[bijufrancis]

Hi,
In the attached file 1st Column are the vehicle numbers. The ROW provides the detail of the payment made each day through different modes through out a month. Digit 9 is the number which represents the vehicle has not paid and gone free.

I want to find the following:
1. the first three trips for the whole month wherein the vehicle has paid consequently 3 times.
2. In case the vehicle has not paid in the 2nd or 3rd time should be shown in Day 2 or Day 3.

 

[AliGW]

I don't see any formatting anywhere - you need to manually mock up what you are trying to achieve.

Thanks.