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.
Experimental Hip-Hop/Pop Album Mixing Category: Audio Editing, Audio Engineering, Audio Production, Audio Services, Music, Music Management, Music Production, Sound Design Budget: $250 - $750 USD
22-Dec-2025 05:04 GMT
deploynment on seperate vps and paynment integration of paytm Category: Affiliate Marketing, App Development, Branding, Content Marketing, Digital Marketing, Email Marketing, Lead Generation, SEO, Social Media Marketing, Web Development Budget: ₹100 - ₹400 INR
22-Dec-2025 05:03 GMT
Customizing Telegram with Extra Features Category: Android, Flutter, IPhone, Mobile App Development, Node.js, PHP, PostgreSQL, React Native Budget: ₹12500 - ₹37500 INR
22-Dec-2025 05:03 GMT
US Shopify Ads Specialist Category: Advertising, Conversion Rate Optimization, Digital Marketing, Facebook Ads, Google Ads, Marketing Strategy, Shopify, Social Media Marketing Budget: $10 - $50 USD
22-Dec-2025 05:03 GMT
Investor-Ready Business Plan Development Category: Business Analysis, Business Development, Business Plan Writing, Business Plans, Business Strategy, Business Writing, Financial Analysis, Market Research Budget: $15 - $25 USD
Meta Ads Strategy & Monitoring Category: A / B Testing, Advertising, Analytics, Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Instagram Marketing, Internet Marketing, Social Media Marketing Budget: ₹12500 - ₹37500 INR
22-Dec-2025 05:01 GMT
Cinematic Private Video Edit Category: Adobe Premiere Pro, After Effects, Animation, Final Cut Pro, Motion Graphics, Video Editing, Video Post Editing, Video Services Budget: $30 - $250 USD
Full Service E-Commerce Website Category: CSS, Graphic Design, HTML, PHP, UI / User Interface, UX / User Experience, Web Development, Web Design Budget: ₹37500 - ₹75000 INR
22-Dec-2025 04:57 GMT
Animated WHS Video Updates Category: Adobe Premiere Pro, After Effects, Animation, Motion Graphics, Script Writing, Video Editing, Video Services, Voice Over Budget: $250 - $750 AUD
Engineering Product Reveal Video Category: Adobe Premiere Pro, After Effects, Animation, Branding, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹1500 - ₹12500 INR
22-Dec-2025 04:52 GMT
PDF to JSON Data Extraction - 21/12/2025 23:41 EST Category: API Development, Data Extraction, Data Processing, Documentation, Google App Engine, JavaScript, JSON, Python, Scripting, Software Architecture Budget: $30 - $250 USD
