• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting


New Member
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.



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