• 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

Shabbo

Member
Dear Sir,
I wanted to highlight those which are matching with reference number and amount with color ‘YELLOW”
Difference upto Rs 2 can be ignored (excess or less)
If Voucher number is matching but amount is not matching wanted to color “BLUE”
If Voucher number is not matching then wanted to highlight with “RED”
 

Attachments

  • Book8.xlsx
    267.2 KB · Views: 3
Back
Top