Find Jobs
Hire Freelancers

Excel 2013 Conditional Formatting Formulas

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
Use conditional formatting formulas to check range of text strings in cells against a column of strings for any match. If match is found then format cell checked with green; if no match is found make the cell red. Format Painter does not appear to update the relative cell reference within the conditional formatting formula when copying to other cells.
Project ID: 12823637

About the project

30 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average $71 USD for this job
User Avatar
Hi, I am good at Excel and conditional formatting. Plz provide me the excel file details further to get the scope of work. Looking forward to discuss in the chat.
$34 USD in 0 day
5.0 (704 reviews)
7.7
7.7
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$133 USD in 2 days
4.9 (235 reviews)
7.4
7.4
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small business registered in the state of Illinois. I could bill you as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$50 USD in 1 day
4.8 (165 reviews)
7.0
7.0
User Avatar
Greetings! Conditional formatting is a bit tricky. I can understand what you are encountering having gone through similar problems myself. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$80 USD in 2 days
5.0 (142 reviews)
6.5
6.5
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$50 USD in 1 day
5.0 (192 reviews)
6.7
6.7
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only. It depends on number of strings to check. If the number of strings is large VBA might be the only solution to use
$30 USD in 0 day
5.0 (242 reviews)
6.4
6.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$50 USD in 1 day
4.9 (131 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 3 days
4.9 (115 reviews)
6.2
6.2
User Avatar
"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan. 19th January (15)
$30 USD in 3 days
4.8 (123 reviews)
6.1
6.1
User Avatar
Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on 50 projects.
$40 USD in 0 day
5.0 (61 reviews)
5.6
5.6
User Avatar
Hello , I am Saidul . I am expert in Data entry work. I have read your project details and I am a hard worker; I feel that I work quickly and concisely with little direction. I have excellent skills in all Microsoft Office packaged in particular Word and Exce, web search, google spreadsheet etc.l and have good skills in spreadsheets. I have always dealt with enquiries from clients and feel that I have excellent communication skills and the ability to explain information to client carefully in a format that they will understand. I am available for interview at short notice should you be interested in my skills further. I will give 5+ hour a day for your task and I hope my work accuracy will be 100% accurate. If you think I have capability to do your job you can contact me via massage. Thank you Regards, Saidul
$88 USD in 3 days
5.0 (31 reviews)
5.3
5.3
User Avatar
Hi, I am a scientist by profession with extensive experience in creating Excel-based templates for reformatting and applying calculations to complex datasets. I regularly use conditional formatting to help visualise different groups of values within these datasets, and I believe I should be able to quickly achieve the required outcome for your spreadsheet. Please see my portfolio for some examples of my previous work, and don't hesitate to contact me if you have any questions. Thanks, Dan
$50 USD in 1 day
5.0 (47 reviews)
5.1
5.1
User Avatar
I have excellent command on MS Excel and know how to use conditional formatting rules. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
$30 USD in 1 day
4.9 (35 reviews)
5.0
5.0
User Avatar
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Creating Conditional Formatting and Data Validation with Excel VBA Programming. I can apply format according to your description. I also have experience of Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
$45 USD in 1 day
4.7 (47 reviews)
4.8
4.8
User Avatar
I am a Data Entry Expert and proofreading with 15 years of experience. I also have experience in word, PowerPoint and excel. PDF to Word and Excel. My motive is to make my employer Happy without additional charges and time, so please, give a chance.
$30 USD in 1 day
4.6 (53 reviews)
4.9
4.9
User Avatar
Hi, I am a native English speaking Finance professional with over 15 years experience using Excel. I can help you with your conditional formatting. I would propose complete your project by checking your current formula within the conditional formatting - particularly how the cell references are set up (with absolute references, or not). I will then look to make any necessary changes to the formula and copy it across all your cells. I welcome the opportunity to discuss your project further and to work with you. Thanks & regards Melanie
$46 USD in 3 days
5.0 (12 reviews)
4.3
4.3
User Avatar
Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, VBA code and presents data in a clear and simple way.. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? Ps. This could be one of my first projects on Freelancer.com, so give me the chance to proof that i'm really good business partner. Best regards, Rafael
$30 USD in 2 days
4.9 (16 reviews)
4.5
4.5
User Avatar
I want to work with you to truly understand what you need. I am comfortable with conditional formatting and if it doesn't work as you mentioned, I can create a macro to shade the boxes for you. Depending on your ultimate goals we can look at some of the other features Excel has such as "spark lines" and icon sets. You really want the user to be able to quickly identify some piece of information. The key is turning raw data into information and directing the user to the key data points. I look forward to working with you and learning more about your business.
$111 USD in 3 days
5.0 (3 reviews)
4.4
4.4
User Avatar
We are team of excel experts and have worked on conditional formatting before. We can help you with your requirements. Looking forward to your reply
$35 USD in 1 day
5.0 (19 reviews)
3.9
3.9
User Avatar
Dear I am an excel professional having hands on expertise in conditional formatting I will do your project as per your requirement you can check on my portfolio dashboard video. Best regards Humayoon
$75 USD in 1 day
4.7 (10 reviews)
4.1
4.1

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jan 18, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.