Excel vba conditional formatting formula jobs

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

...with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a must. Ideal Ski...

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + ...

I am in search of a legal expert to review a federal complaint, specifically to examine the legal arguments, factual content, and case law references. This document is currently in Word format and you...follows an acceptable format for the US District Court Ideal skills & experiences should include: - Extensive Legal Knowledge: Familiarity with legal argumentation and case law will be essential to ensure the document is accurately structured and persuasive. - Legal Writing Expertise: The ability to bring clarity and precision to complex legal concepts is key. - Formatting skills: An understanding of US District Court complaint formatting requirements is a must. Your input will greatly aid in making this complaint as strong as possible. Your expertise will be highly va...

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The ideal ca...

We're seeking an experienced developer company to help upgrade a state-of-the art startup MEMBERSHIP PLATFORM; website, iOS & Android apps, a...email -Braintree -PayPal -AWS email automation (all membership emails, notifications, requested reminders etc) -Zendesk (set up by Zendesk specialist in conjunction with web developer; API, macros, articles) -MailerLite (API syncing members for company newsletter) -Admin panel (custom) -Google Developer -Apple Developer -Facebook Developer -Userway (ADA) plug in -A few plug-ins text formatting etc. You will be required to sign an NDA. Chosen developer company will sign a monthly Service Agreement. This project is for hire. Completed project is our intellectual property and will pass on to us. Thank you for your int...

I am in need of a professional who can create captivating marketing content to bolster our brand, generate lead...LinkedIn -Build LAnding Pages to help funnel customers into further engagement. - Design visually appealing infographics that tell our brand story and catch the eye of potential customers Ideal Candidate: - Experience in creating marketing content for a B2B audience - Proficient in SEO techniques and keyword research - Ability to create aesthetically pleasing infographics - Skilled in writing and formatting engaging social media posts - Prior experience in lead generation content creation is a plus Your work will be pivotal in increasing our brand recognition and driving leads. If you possess the skills and creative flair for this task, I look forward to receiving your...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

Start your offer with the word in the att...Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 hours of starting our...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I need a Python Selenium application that can scrape blog posts from Site A and post them on Site B. Key Requirements: - The Python app should be built using Selenium for web scraping and automation. - It should be able to extract blog posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Exper...posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Experience: - Proficient in Python, with experience in building web scrapers. - Strong knowledge of Selenium for web automation. - Previous experience with data extraction and manipulation. - Understanding of web protocols and site structures. - Familiarity with blog post formatting and pub...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

...experienced developer to create a custom Visual Studio Code extension tailored to my specific requirements. Key Features: - The extension should allow me to define my own set of rules - Specifically, I require the ability to create code formatting rules and code highlighting rules Rule Application: - The code formatting rules must be applicable both automatically upon file save and manually upon command execution. Ideal Skills: - Expertise in creating Visual Studio Code extensions - Proficiency in JavaScript and TypeScript - Prior experience with code formatting and syntax highlighting - Understanding of code linting and analysis - Strong communication skills to understand and implement my unique set of rules. Please provide examples of your previous work in...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including tr...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I'm in need of someone with excellent typing skills to format my business reports. This project is about making my reports look sharp and professional in Microsoft Word (.docx) format. Key requirements: - Excellent typing skills are key, as the reports will need to be retyped into the desired format. - Experience with business documents is a must. Formatting needs to be polished and consistent. - Proficiency in Microsoft Word (.docx) is essential, as this will be the final format of the reports. This is a straightforward job for someone with the right skills, and I'm looking to complete it in a very timely manner.

...BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designin...

As we chatted about: I have a large Word document (57 pages / 8,046 words) that requires a meticulous conversion to HTML. It's imperative that this conversion maintains the document's original presentation. Key aspects for this project include: - The HTML output must mimic the original Word document's structuring and formatting. - Special attention has to be given to making it match exactly to the Word document. This includes font type, size and spacing. note there are images as well to be included. - It will need to be mobile friendly as such. - An excellent understanding of HTML, CSS and Microsoft Word is vital. - Strong experience in converting documents from Word to HTML is desired. Applicants should be proficient in working with detailed documents ...

...comprehensive editing, including correcting typos, ensuring consistency of fonts, font sizes, and styles, re-formatting structure, and modernizing images and layout. Additionally, I'm looking for a professional who can update the branding of the document. Key Responsibilities: - Correcting typos and grammatical errors throughout the document - Ensuring consistency of fonts, font sizes, and styles - Reformatting the document structure for better readability and flow - Modernizing images and layout to give a fresh, updated look - Creating new branding guidelines and applying them to the document Ideal Skills & Experience: - Proven experience in comprehensive editing, copy editing, and document formatting - Strong understanding of branding and design principles - ...

...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm in need of a professional resume tailored for the technology industry. This res...my expertise in DevOps and Site Reliability Engineering. The final resume should be provided in PDF format. Ideal freelancers for this project would have: - Experience in resume writing, specifically for technology jobs - Understand ATS compliance to ensure the resume doesn't get overlooked - Ability to highlight specific skills for DevOps / Site Reliability Engineering - Exceptional writing, formatting, and design skills to make the resume stand out Craft the content carefully, with a full grasp of the technology industry standards and jargon. Your attention to detail will be vastly appreciated. Looking forward to working with a professional who can enhance my chances of getting notice...

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

As your client, I'll need focus...primary tasks: - **Color Correction:** I have several photographs that require professional color correction before they're suitable for online publishing. You should have an eye for detail and experience in using popular photo editing tools. A background in graphic design would be an added advantage. - **Document Formatting:** Alongside the graphics, I also have documents that need proper formatting. Ideal candidates have prior experience with professional document design and formatting, varying from layouts to font choices. For both tasks, strong attention to detail, technical proficiency, and an understanding of aesthetics are crucial. If you have experience in these areas and can deliver high-quality, professional outp...

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

I need a proficient Microsoft Word expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous ...templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's crucial that the template looks professional, clea...

I'm in need of a professional who can perfectly format my 100-page Word document. The document requires: - Adjusting the page layout - Ensuring consistent and appealing font styles and sizes are used throughout - Ensuring all tables are well-formatted and visually appealing In your application, please focus on showcasing your experience in Word document formatting. I don't need any graphics or images inserted into the document, just a clean and consistent format.

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

...openai that can take input as lists of 'subject, problem, idea', and output completed posts, but you're welcome to use a different AI if you want to. We've even generated a list of prompts to generate such good content, so this should be a very easy project. We just need you to have an AI generate the content and make sure all the details are correct. -that the AI didn't hallucinate anything. Formatting is very basic: Subject posts: a few lines of text and some tags. (subject posts are often placeholders for the more interesting content: problems and ideas) Problem posts: a few lines of text, tags, a few statistics with sources cited, and a section for "potential harm". Idea posts: : a few lines of text, tags, and a few statistics with sources ...

...while maintaining the content, context, and style of the original material. - Convert PDF documents into editable Word formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish with an excellent command of English. - Proven expertise in translation with a strong understanding of linguistic nuances between Spanish and English. - Proficient in converting PDF documents into editable Word formats. - Experience in formatting and editing Word documents with attention to detail. - Ability to work independently and deliver high-quality work under tight deadlines. ...

I have a PDF file that requires formatting changes and an interactive email submit button to receive completed forms. The PDF must be accessible and functional on both desktop and mobile devices. Document is complete- just need small edits for email and submit button (4 pages in length) Key Requirements: - Formatting Changes: I need assistance in making specific formatting changes to the PDF. This may involve reorganizing content, adjusting layouts, or ensuring consistency in font and style. - Interactive Email Submit Button: I want to add an email submit button to the PDF. This button should allow users to fill the form digitally, then submit the completed form directly via email. - Cross-Device Compatibility: The PDF must be compatible with both desktop and mobile...

I need to create alternating colors for rows 19 to 28 and specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with setting up a conditional formatting rule that automatically alternates the row colors, regardless of row insertion, deletion, or hiding? https://docs.google.com/spreadsheets/d/1SwqtiYIrZdO8p6YOxKsOx5MTgE3qQwAajTKIImYWHmE/edit#gid=1503373653

I am looking for a freelancer who can help me sign my restobar business on Grab Food app by creating a menu template on MS Excel. The menu is currently available as a picture and needs to be converted into a simple spreadsheet format that meets Grab's requirements. Key Requirements: - Convert picture based menu into an Excel sheet for Grab Food app - Keep the menu descriptions short and simple - No need for special formatting or design elements, just plain text Ideal Skills: - Proficiency in MS Excel - Accurate data entry skills - Familiarity with food service industry or Grab Food app would be a plus

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with ...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessary.

Hi, as discussed. I will be working on your project and formatting references and in text citations from APA to AMA style within 24 to 48 hours.

I'm in need of a competent and creative ebook designer who can format my short fiction ebook. Key Requirements: - The ebook must adhere to a classic formatting style - As it's a work of fiction, the design should compliment the narrative without being overly complex I have a very tight deadline so we'll need to move quickly. I only need the internal design, so I'm not looking for cover design. It's a short ebook intended for Amazon and Kindle, so experience in formatting for these platforms would be a plus. I look forward to finding a freelancer who can bring my story to life in a visually appealing way.

I'm looking for an experienced Shopify developer to help me make a quite smilar a product page. like this Specifically, I'd like this new page to be built using 'Pagefly' or sim...are accurately transferred to the new page. - 'Pagefly' Experience: Proficiency in using 'Pagefly' or similar tools is a must. This will ensure that the modifications to the design and layout can be achieved without compromising the overall quality of the page. The ideal candidate for this project would be a Shopify developer with prior experience with 'Pagefly'. Experience in improving the formatting and layout of product descriptions would be a plus, although not mandatory. Please share examples of your prior work, particularly if they involve similar...