• 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

    Hui...

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

Conditional formatting

bijufrancis

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

Attachments

AliGW

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

Thanks.
 
Top