
Closed
Posted
Paid on delivery
So this is the task. There is a look up of different cities Tampa, Pune, Chennai etc. I place people across Jan to Dec and it should calculate the net cost. If total cost is more than allowed total, then turn the cells P2 - P5 red. If less than, turn blue. If equal, turn is: green.
Project ID: 40447834
56 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
56 freelancers are bidding on average $22 USD for this job

Hi, I am a skilled Excel professional from Vietnam with 25+ years of experience. I can help you with formulas, calculations, and conditional formatting. I am currently available and ready to commence work immediately. How can I help you with your Excel task? Best regards, Duong
$30 USD in 1 day
7.0
7.0

I would do it now. I would apply conditional formatting accordingly. As an individual who prioritizes both time-saving and accuracy, I apply my skillset to synthesize complex data into easy-to-comprehend metrics. Let's collaborate on turning your vision into a reality by weaving the analytic capabilities of Excel at your service.
$25 USD in 1 day
6.5
6.5

I"M Certified VBA Programmer (MACRO), MBA. AVAILABLE TO START IMMEDIATELY. FREE SAMPLE PROVIDED.,,. I will develop an Excel VBA solution to calculate net costs for your city resource allocations from Jan-Dec and implement the requested P2-P5 conditional formatting logic. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$19 USD in 1 day
6.6
6.6

Colors according to the total cost, OK, I understand! Now just click on the [Reward] button so we can get started
$30 USD in 1 day
6.6
6.6

Hello it's elementary task I can complete now I have several years of experience with Excel Macros and Visual Basic for applications.
$16.40 USD in 1 day
6.1
6.1

Hello, I am an experienced Excel specialist with strong expertise in conditional formatting and cost-tracking logic, and I will build you a clean, fully automated spreadsheet that calculates net costs across cities like Tampa, Pune, Chennai, and others for each month from January through December. I will set up the sheet so that when you assign people across months, the total cost automatically updates, and based on the comparison with your allowed total, cells P2 through P5 will instantly change color—red if over budget, blue if under budget, and green if exactly equal. The system will be user-friendly, accurate, and easy to maintain. I am available to start immediately once you share the specific cost data and budget limits. Regards, Zafar
$30 USD in 1 day
6.2
6.2

Hi, I can develop an Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
$30 USD in 3 days
6.0
6.0

Hi, I’ve worked on many similar tasks before and can share an example if needed. I also have experience with Excel VBA and Excel and would be happy to assist. Feel free to message me if you'd like to discuss the details.
$25 USD in 1 day
5.3
5.3

Hello I can create the lookup-based cost calculator for different cities with conditional formatting where cells P2–P5 turn red if total cost exceeds the limit, blue if below the limit, and green if equal. I can deliver this accurately and efficiently. Regards Muhammad
$30 USD in 1 day
5.1
5.1

Excel professional VBA developer, checked the file and the requirements and eady to do the required. Relevant experience and sample reference works and clients' reviews in links below. Regards. https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
$30 USD in 1 day
5.0
5.0

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
$20 USD in 1 day
5.0
5.0

Hello, I can help you with this Excel task using formulas, conditional formatting, or VBA macros as needed. I understand that the sheet should automatically calculate the net cost from Jan to Dec based on selected cities like Tampa, Pune, Chennai, etc. I will make sure cells P2–P5 turn: * Red if the total cost is above the allowed total * Blue if it is below the allowed total * Green if it is exactly equal The workbook structure and calculations will remain accurate and easy to use. I can start right away and deliver a clean working solution. Feel free to message me to discuss the file and requirements further. Kind Regards, -Habib
$20 USD in 1 day
4.7
4.7

So you need a city-based lookup where you place people across Jan to Dec, the workbook calculates the net cost, and cells P2 to P5 turn red when total cost exceeds the allowed total, blue when below, and green when equal, happy to take that on. My approach is to set the city lookup table on a hidden Settings tab with cost rates per city, drive the Jan to Dec layout off SUMPRODUCT or SUMIFS so the net cost recalculates the moment you place anyone, then layer conditional formatting on P2 to P5 with three formula-driven rules (red for over, blue for under, green for equal to the allowed total) so the colors shift instantly without macros. I've built this kind of lookup-driven cost tracker recently including a 26-region sales control tower with 1,624 formulas and a pharmaceutical pricing model with 3,544 SKUs, can have it delivered within 24 hours at $25 USD.
$20 USD in 1 day
5.2
5.2

Hi I have 15+ years of experience in advance excel VBA and business intelligence and I can complete the work most efficiently. I can start immedietly . Thanks Shivani
$10 USD in 1 day
4.7
4.7

I would love to take on your project and put my extensive experience in all things Excel and Excel VBA to work. Over the past seven years, I have developed a deep understanding of the intricate workings of Excel; from simple formulas to complex macros. Your task is right up my alley and I can confidently say that I will be able to deliver exactly what you need - an automated, error-free solution that calculates net costs with visual indicators. Apart from my technical expertise, I am known for my attention to detail and strong problem-solving skills. Complex lookups and dynamic calculations are a staple in my day-to-day work, making me fully equipped to handle the task at hand. Additionally, I am reliable, efficient, and committed to meeting deadlines; you can rely on me to complete the task accurately and on time. In conclusion, let's turn this project green together! With my deep understanding of not just Excel but also your specific needs, I'm confident that I can create a sustainable solution that not only satisfies but surpasses your expectations. Let's get those cells color-coded correctly for you!
$15 USD in 1 day
4.2
4.2

Hi, I’ve reviewed your project and can help you get it done quickly and accurately. I’m Sarim Ali Khan, a top-rated freelancer specializing in data automation, analysis, and workflow optimization. My clients hire me because I deliver on time, on budget, and with zero guesswork. I can start right away and share a quick sample if you’d like. Let’s chat about the details and get you results — fast. Best, Sarim
$10 USD in 1 day
4.3
4.3

I can do it for you immediately, please choose me. I can complete it quickly and deliver it directly to you.
$19 USD in 1 day
3.5
3.5

Your Excel model will automatically calculate net placement cost across cities and months (Jan–Dec), pull city-based rates dynamically, and instantly flag budget status with clear color indicators for P2–P5. I will build a structured, formula-driven Excel system using XLOOKUP/INDEX-MATCH, SUMPRODUCT, and Conditional Formatting to ensure accurate cost aggregation, city-wise lookups (Tampa, Pune, Chennai, etc.), and real-time budget comparison against allowed totals. ➡️ My work process: ➤ 1. Data Structuring: Organize city rates, monthly allocations, and cost tables into a clean, scalable Excel layout. ➤ 2. City Lookup Engine: Use XLOOKUP/INDEX-MATCH to fetch correct per-city cost values automatically. ➤ 3. Monthly Cost Mapping: Apply SUMPRODUCT logic to calculate Jan–Dec placement totals efficiently. ➤ 4. Net Cost Calculation: Combine all allocations into a single dynamic net cost output. ➤ 5. Budget Comparison Logic: Compare net cost against allowed total with precise logical formulas. ➤ 6. Conditional Formatting Rules: Apply rules to P2–P5 (red if over budget, blue if under, green if equal). ➡️ Why choose me: ✅ Rising Star ⭐ freelancer status on the platform ✅ Strong expertise in Excel automation, lookup systems, and financial modeling ✅ Completed similar Excel dashboard and automation projects; clients can view them in my profile reviews Regards, Abdullah Lashari
$15 USD in 1 day
2.9
2.9

I have extensive expertise in Excel and its advanced functionalities, which I believe make me the perfect fit for your project. I've been an Excel Specialist for years now, comfortably navigating everything from Formulas, VBA, Pivot Tables, Power Query to name a few - all skills that are directly applicable to your task. One of my core strengths lies in Excel Dashboards & Reporting. Here, I have built complex KPI tracking systems, interactive dashboards, charts, and visualizations- essentially marrying data with a meaningful presentation. I understand the value of turning numbers into insights and bringing color and context into play. In this case, turning red when total cost exceeds allowable limit or blue if it's lesser creates a very clear visual impact for users. Another skillset that precisely aligns with your requirement is Power BI & Data Management. It ensures not just efficient data modeling but seamless reporting integration too. Lastly, let me assure you of my uncompromising commitment to accuracy and speed. With me on board, you don't just get proficiency but also reliability for timely delivery without sacrificing on quality. You can trust me with the job:)
$19.99 USD in 1 day
2.7
2.7

From Pune Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
$10 USD in 7 days
2.4
2.4

Brooklyn, United States
Payment method verified
Member since Sep 12, 2013
$30-250 USD
$10-30 USD
$10-30 USD
$10-30 USD
$30-250 USD
$15-25 USD / hour
₹600-650 INR
₹600-1500 INR
₹750-1250 INR / hour
$8-15 USD / hour
₹600-1500 INR
₹600-1500 INR
$15-25 USD / hour
$30-250 USD
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
$10-30 USD
₹750-1250 INR / hour
$15-25 USD / hour
$10-30 USD
₹600-601 INR
₹12500-37500 INR
₹12500-37500 INR
₹1500-12500 INR