I am looking for part auto colour coding and part Data match reconcilliation sheet.
After copying over data from the Client side in the "Client Raw Data" tab and my Company raw data in the "My Company Raw Data" tab
in the results tab
I want to try and match up the data to see where there is a break in the data set for me to investigate further.
For the purpouse of making it easier to understand I have matched by line the client side and My company side results in the "Results" tab - however this my not be organised this way, as data on both side could be unfiltered or sorted or lines missing. So this is just so it is easier to view.
I need
a) Where there is a match for the cells to go green b) Company Name match - this is based off if the name fully matches on both the client side and mine or if an alternative name matches e.g
Client name is Delta on the company side , however on my company side it shows as Delta 1. It has to search the Alternate name tab - to see if the alternate name matches or not?
c) where there is an amount only match for example a message should appear in the Amount match cell " Exact amount found only) - thus I would need to investigate further.
d) I need the colour coding as per the example - this is to help me work though the data and errors quickly as possible.
I dont want to use macros or VBA - as I want to try and replicate this my self by looking at the formulas and colour coding myself.
Professional Content Writer Needed Category: Article Rewriting, Article Writing, Blog Writing, Content Creation, Content Writing, Copywriting, Creative Writing, Social Media Marketing Budget: €250 - €750 EUR
01-Feb-2026 05:04 GMT
Strategi Kemitraan Korporasi Category: Account Management, Business Analysis, Business Development, Business Strategy, Lead Generation, Market Research, Proposal Writing, Sales Management Budget: $15 - $25 USD
01-Feb-2026 05:04 GMT
Realistic Gas Leak Flow Animation Category: 3D Animation, 3D Modelling, 3D Rendering, After Effects, Animation, Blender, Houdini, Visual Effects Budget: $10 - $11 USD
01-Feb-2026 05:02 GMT
Optimize Your Packet Category: AngularJS, API Development, Django, Docker, Docker Compose, Google Maps API, GPS, JavaScript, Python Budget: $10 - $200 USD
01-Feb-2026 05:02 GMT
Modern Wedding Album Layout Category: Adobe InDesign, Photoshop, Album Design, Graphic Design, Illustration, Logo Design, Photo Editing Budget: ₹1000000 - ₹2500000 INR
01-Feb-2026 05:02 GMT
VIDEO EDITOR NEEDED for faceless YouTube channel -- 2 Category: Adobe Premiere Pro, After Effects, Animation, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services, YouTube, YouTube Video Editing Budget: ₹12500 - ₹37500 INR
Personal portfolio Papers on AWS & AI/ML Category: AWS Lambda, AWS SageMaker, Cloud Computing, ETL, LaTeX, Model Deployment, Research, Research Writing, Technical Writing Budget: ₹12500 - ₹37500 INR
01-Feb-2026 04:57 GMT
Short Post & Reel Creation Category: Article Writing, Content Creation, Content Writing, Copywriting, Social Media Marketing Budget: ₹750 - ₹1250 INR
01-Feb-2026 04:56 GMT
Long-Form Professional YouTube Video Category: Adobe Premiere Pro, After Effects, Audio Editing, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
01-Feb-2026 04:55 GMT
MVP Development for 1-1 Messaging App -- 2 Category: Agile Development, Android, IOS Development, IPhone, Minimum Viable Product, Mobile App Development, Security, Startup Consulting, Startups Budget: ₹250000 - ₹500000 INR
01-Feb-2026 04:54 GMT
Modern Sunset-Inspired Wedding Sign Category: Adobe Illustrator, Photoshop, Creative Design, Digital Art, Digital Design, Graphic Design, Illustration, Photoshop Design, Typography, Visual Design Budget: $250 - $750 AUD
