Conditional formatting if cell is not blank jobs

Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect verification details (employee number, name, date of birth, boss's name, and last four digits of cell number) through a structured conversation. The system will validate user inputs against an API and terminate the conversation after three invalid attempts. Upon successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on ...

I'm looking for a professional to help me format my Kindle e-book and design a cover. Key requirements: - Experience in creating e-books for Kindle - Proficiency in cover design - Ability to deliver a polished, professional product Please note: The content of the e-book is already completed, so the main focus will be on formatting and cover design. If you have a portfolio of previous e-books you've worked on, it would be great to see.

...posting the ads daily without human intervention. - The ads must be posted with consistent formatting and accuracy. - Development and implementation should be carried out with a focus on the user's perspective, ensuring the ads are easy to understand and engage with. Ideal Skills and Experience: - Proficiency in web development and automation technologies. - Previous experience with classified ad posting in Lara classified - Strong attention to detail and the ability to deliver a user-friendly experience. - Timely and consistent communication to ensure the project is on track. Please note that the specifics of which classified website the ads should be posted on, the category of ads, and other details have not been specified. The developer will be responsible...

I'm in need of a reliable data entry professional to input a mix of text, numeric, and image data into a spreadsheet. The job involves inputting between 100 to 500 entries. Ideal Sk...Ideal Skills: - Proficiency in data entry with a strong attention to detail - Ability to handle different data formats (text, numeric, and images) - Experience in spreadsheet software, ideally with knowledge of conditional formatting and data validation. The data may need to be sorted and organized, so any experience or skills in data organization are a plus. It would be beneficial if you have a basic understanding of different types of data and their implications for the final use of the spreadsheet. Please be prepared to propose a basic template or format for the data entry ...

I need a professional to format a Chicago bibliography for my assignment from a list of journal article links and website links. Key Requirements: - Chicago Style: The bibliography should adhere strictly to the Chicago citation style. - Journal Articles: You will be formatting the references primarily from journal articles. - No Annotations: I do not require any annotations, just the citation for each source.

...workwear business. The website must have a feature for customers to be able to customise a blank product with their own logo/design. The website's primary objective is to host a substantial number of products for sale, so experience with building comprehensive online stores is a must. Key Requirements: - E-commerce Expertise: I need a freelancer who's well-versed in e-commerce site development. Your prior experience with creating such platforms, particularly with a product range exceeding 100 items, will be highly beneficial. - Payment Gateway Integration: The website should allow customers to pay via credit card and PayPal. Your proficiency in integrating these payment methods securely and seamlessly is essential. - Customizable Design: While I h...

I am in need of professional help to bring structure and uniformity to my ...professional help to bring structure and uniformity to my extensive Word document, which is 60 pages. The scope of work will include: - Text and paragraph layout adjustment: This involves ensuring proper alignment, indenting, and spacing across the entire document. - Consistent formatting: I want the document to maintain a uniform format throughout, with common styling in terms of font size, type, text color, and more. The ideal freelancer for this job would have excellent attention to detail, a high degree of proficiency in Microsoft Word, and a background in editorial work or document design. Experience with large word documents is a plus. Your commitment to delivering work on time alongsi...

I need to urgently translate my daughter's Bonafied Certificate from Russian to English. The translation needs to be done within 4 hours. Key Requirements: - Translate a Bonafied Certificate document from Russian to English. - Maintain the original formatting of the document. Ideal Attributes: -Looking for certified translator - Fluent in both Russian and English. - Prior experience in document translation. - Ability to work under tight deadlines.

We are looking for a talented UX/UI designer to create a simple mobile app. The main function of the app is to receive notifications, similar to emails or SMS. A total of 12 layouts need to be designed. The logo and colors are already finalized, and there is an existing old design in Figma. Requirements: Experience: Proven experience in UX/UI design for mobile apps. Design: Simple, intuitive, and user-friendly layouts based on the existing Figma design. Compatibility: Designs should be suitable for both iOS and Android. Components: The layouts must include all necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required Layouts: 1. Splash Sc...

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tree format.

I need a comprehensive and professional formatting of a government project report. This report is aimed at analyzing the effectiveness of current government programs, identifying areas for further improvements and suggesting recommendations for future initiatives. The needed formatting requirements include: - Font style and size - Heading styles - Margins and spacing - Including images, tables etc. Ideally, you possess a keen eye for detail and an understanding of government report structures. A background in preparing and formatting formal documents or reports is a plus. The project has to be completed ASAP, so time management skills are crucial. Please bid, outlining your relevant skills and estimated turnaround time.

Hi, this is as we discussed breaking this down in two parts really but completing it as a whole. First part older posts not yet done: Same as the other month adding more content to all the older posts that lacked depth and also misc fixes as I go through them, adding images etc.. Estimated around 50k words will be added to these. 2nd Part for newer posts that popped up since the other month (36 posts) Need to add inner links to all of these, a lot of fixes noticed just browsing these... Missing meta descriptions, formatting, missing images and all other fixes + adding content to those that lack depth for the keyword (which doesnt seem to be too many). Ill set this to finish by end of the month but in reality probably before that as I dont have much else going on at...

It is necessary solve two bugs to a Laravel application regard the frontend of condition use php 7.4. if it is necessary you must do changes to the database and the backend

I'm in need of an expert to create an advanced and professional CV builder. This tool should include the following features: - Comprehensive set of inbuilt templates...different industries and positions - Guidance and tips for CV creation incorporating industry best practices and successful strategies - An option to import and edit existing CVs The ideal candidate for this job will have a deep understanding of CV best practices and a proven track record in software development. The software should allow users to customize and adjust the sections and formatting within their CV. This is not just about font and colors. We're looking for an ability to customize and create sections that best represent the user's experience and skills. Your attention to deta...

I'm on the hunt for a talented designer to create a jiu jitsu journal. This journal should be not only a place to log training and progress, but also a source of inspiration and mindfulness. It needs to have a clean and minimalist design. Here's a detailed list of what I am looking for: - Training log section per training session - Technique library or pages dedicated to techniques - Progress tracker which includes tracking for belts, stripes, seminars, competition history - Sections for gratitude, mindfulness, wellbeing, and meditation challenges - Pages with inspirational quotes - Blank pages filled with key questions and prompts about jiu jitsu eg: What are your short, medium and long term SMART goals. What does jiujitsu mean to you? Why should you compete? Wha...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I do...and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If...

...Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more intermediate or even advanced functions. Your ability to adapt to varying complexity levels and your experience in integrating different fu...

We are a marketplace an have an excellent website (Build in Next Js) that is facing some indexing issues in google. I'm looking for an expert in programmatic SEO (pSEO) to help me resolve these issues. We currently have 3.8 M pages build through programmatic SEO and only 136K pages are indexed. Key Responsibilities: - Identify & resolve the specific indexing problems affecting my website - Suggest and implement strategies to improve website's indexing Ideal Skills and Experience: - Proven track record in SEO, with a strong emphasis on programmatic SEO - Expertise in resolving indexing issues - Excellent understanding of search engine algorithms and indexing processes - High proficiency in SEO tools and analytics Your insights and solutions will be critical in helpi...

...sports, birth & death notices. The ideal candidate for this project should have: - **Experience with News Media Websites:** Experience in creating personalised news media content and working with API content feeds is a must. - **WordPress Development Expertise:** Proficiency in WordPress development is essential. - **E-Commerce Skills:** Understanding of e-commerce functionalities and payment gateway integration. - **Marketing and Analytics Experience:** Knowledge of inbound and outbound marketing strategies, data collection (email addresses, cell phone numbers) and data measurement is required. You will need to be able to set and achieve traffic and revenue targets and earning comission and success fees as part of an on going contract renumeration. N...

...both iOS and Android. This application is envisioned to transform our approach to maintaining fleets and managing stock, and facilitating seamless communication with our workshop. The application should include the following features: - Fleet Maintenance Organisation: An effective and user-friendly system to manage our service schedules and gather data on both maintained and pending cases. - Comprehensive Service Dockets: Tools to record detailed information on every job, including automatic cell population for standard information. - Stock Management: Features to keep track of tyres and other parts available in each of our service vehicles. - Reminder system: Identifiers to highlight upcoming work and parts requiring attention, ensuring our team is always prepa...

Hi im looking for someone to write my book its about a 17 yo girls on the street with a baby and my life

I have a Google document that I need converted into a Word document, specifically in .docx format. Special Requirements: - The Word document's formatting should mirror the existing Google document's formatting. - The Google document includes images that need to be accurately transferred into the Word document. - No other specific formatting is required. Ideal Skills: - Proficiency in Google Docs and Microsoft Word. - Experience in handling image transfers between different document software. - Attention to detail to ensure the final Word document looks identical to the original Google document.

...text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no experience with image or table convers...

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in ...professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formu...

I'm looking for a professional who is proficient in converting PDF files to Word documents. This project entails: - Working with a PDF file that primarily contains textual content. - Ensuring the Word document mirrors the PDF format exactly, from text placement to style. - Operating within a Windows environment. The ideal freelancer should have superb attention to detail, and should deliver the work in a timely manner. Experience with Adobe Acrobat and Microsoft Word is highly desirable. Accuracy and format preservation is of utter importance in this task.

I require a freelancer with excellent Word processing skills and a solid understanding of professional resume layouts. You'll be tasked with formatting a resume from a PDF into a Word document. Here are the key project requirements: - Format the resume in Word maintaining a clean, professional layout The word Doc is the content I want it to be. The PDF is how I want it formatted. As the files have my personal information I don't want to attach them just yet. The documents are only one page

I have a simple text-based PDF file that I need converted to a fully editable Microsoft Word document. Key Requirements: - The purpose of this conversion is to allow for easy content modifications, so the document should retain the same content layout as in the PDF. - No complex formatting is present, just the text that needs to be edited. - The final Word document should be compatible with Microsoft Word only. Ideal Skills and Experience: - Proficient in PDF to Word conversion tools or manual typing to maintain document integrity. - Expertise in Microsoft Word to ensure the best conversion for editing purposes.

I have a PDF file that I need converted into a Word document. The purpose of this conversion is to enable editing of the contents within the file. The layout of the PDF file is quite complex as it contains various images and tables. I would appreciate if the Word document could be formatted in a standard business format. Ideal Candidate: - Proficient in converting PDFs to Word - Experience with complex layout conversions - Attention to detail in formatting - Understanding of standard business formatting

I want a skilled PHP developer with experience in form handling to create a script for me that will block a form's submit button until certain conditions are met. Key Requirements: - The button should only become active if the user types in any text. This means if the form is left blank or a field is left empty, the button should stay inactive. - After clicking the button, if the conditions are not met, I want an error message to be shown to the user. This is to ensure that they understand what is expected before the form is submitted. The form is working inside an wordpress website but was made with php

...of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessary skills ...

I am looking for a freelancer who can help me with simple copy-paste tasks for my website. Key Responsibilities: - Copying text content from various sources an...them onto the website - Ensuring correct placement of the text within the website's structure Ideal Skills and Experience: - Proficiency in basic web browsing and text editing - Attention to detail for precise copying and pasting - Prior experience with content management systems (CMS) is a plus, but not required This is a straightforward job that doesn't require any formatting skills, just the ability to accurately copy and paste. The selected freelancer can expect ongoing work based on performance. Here is walkthrough of task. We expect 2-3 Lessons per hour on average for fulltim...

I'm seeking a PowerPoint formatting expert to produce a persuasive presentation, revolving around the centerpiece of a techno diagram. Key Requirements: • Expertise in creating and formatting PowerPoint presentations. • Knowledge in creating techno diagrams, despite Hardware, Software, or Network components not specified. • Expertise in designing presentations with a persuasive objective. Note: Techno diagram skill is a must as that's what my project primarily needs. I aim to convince the viewers, therefore, the presentation must be clear, compelling, and visually appealing. If you have such experience, I'd be happy to get your bid.

Please Sign Up or Login to see details.

...flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candidates should have a strong background in Solidworks, with extensive experience in sheet metal panel design and DriveWorks automation. The ability to work swiftly and efficiently, particularly under tight deadlines is a must. I would estimate about 20 or so panel types with each having 2-4 different materials and 2-4 different thickness...

...upgrading my current PowerPoint presentation to a more professional, engaging and modern design. The presentation is concise, with fewer than 20 slides. Key Requirements: - Modern and Clean Design: I want the presentation to have a contemporary aesthetic, incorporating design elements that make it visually appealing. The design should be sleek and uncluttered, enhancing the overall user experience. - Engaging and Interactive Elements: I am looking to incorporate interactive elements that will keep my audience engaged. This could include creative transitions, animations, or other interactive features. - Consistent and Professional Formatting: The presentation should have a consistent formatting throughout, ensuring that it looks polished and professional. This will...

I am looking for a skilled web developer to create a straightforward, one-page website. - Landing Page Content: The page should include a brief description of the services my company offers. - Goal: The primary purpose of the landing page is to provide information to visitors. The target audience for this website is the general public, so the design should be user-friendly and accessible to a broad range of people. Please note that I do not wish to negotiate details in chat. Your bid should reflect your final price for the project. Thank you.

I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the ad...

...Input Data: The input data is in JSON format. - Output Data: The JSON output should be properly formatted and adhere to a specific schema or structure. Skills and Experience Required: - Proficiency in Python programming. - Strong understanding of JSON parsing and formatting. - Experience in adhering to specific JSON schemas or structures. Please let me know your experience in similar projects and any relevant information that would make you a strong candidate for this job. You will pass the name of the input file as an argument and the output file should be the same file name with the .output extension. The input file is attached. Pay attention to the backslashes ("") that make it non-compliant. All the elements to need to be structured correctly. ...

I need assistance with pagination in my 200+ page Word for Mac document, specifically in certain sections. The main issue I'm facing is inconsistent numbering, which seems to be disturbing the flow and continuity of my work. The chosen freelancer should have: - Proficiency in Microsoft Word for Mac (I'm using version 16.85 copyright 2024). - An excellent understanding of pagination issues and how to resolve them. - Experience with document formatting in large Word files. Please only bid if you're confident you can rectify this issue quickly and efficiently.

... This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - Proficiency in Microsoft Word, including advanced knowledge of style and formatting tools. - Strong attention t...

I have less than 100 pages of handwritten medical notes that I need transcribed into a custom template. This project is urgent, and I require the completed transcription in less than a week. Please read this entire ad before replying. NOT FOR AUTOMATED - hand transcribing job. Key Requirements: - Transcription of less than 100 pages of handwritten medical notes and computer printouts. - Custom template formatting (specific layout or structure) - Urgent turnaround time of less than a week Ideal Skills and Experience: - Experience in medical transcription to ensure accuracy and understanding of terminology - Proficiency in creating and working with custom templates - Ability to work under pressure and meet tight deadlines So that I know you are a real person and rea...

...following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of getting 19.88%, the result I am seeing is 1987.95%. This suggests there might be ...

...data for demonstration purposes. Responsibilities: Collaborate with our CRM team to understand our current processes and requirements. Conduct thorough research and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, tone, and formatting across all documentation. Study the agency website () to understand the services and sub-services provided. Set up a full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket manage...

I am looking for a freelancer who can help me with simple copy-paste tasks for my website. Key Responsibilities: - Copying text content from various sources an...them onto the website - Ensuring correct placement of the text within the website's structure Ideal Skills and Experience: - Proficiency in basic web browsing and text editing - Attention to detail for precise copying and pasting - Prior experience with content management systems (CMS) is a plus, but not required This is a straightforward job that doesn't require any formatting skills, just the ability to accurately copy and paste. The selected freelancer can expect ongoing work based on performance. Here is walkthrough of task. We expect 2-3 Lessons per hour on average for fulltim...

I'm seeking an AI developer to create an AI Resume Creator. The primary focus of this project is to take a normal CV / Resume and format it into our company format. It's quite a simple process, populated some fields, removing personal details and then coping the rest of the text into our format. We would want to be able for the AI to use the template we create and it check it each time to make sure we havent updated anything. We would drop the resume / CV into one folder then it would be added to another folder formatted. Ideal Skills and Experience: - Strong background in AI and Machine Learning - Experience in NLP and chatbot development - Proficiency in creating customizable sections for user-friendly interfaces - Understanding of how to analyze user's skills f...

I need to be able to add a title called Experience in blue and the bullets of the experience listed in the Experience document on the last page of this word document. The colors, formatting, font and style should be exactly the same as on the first two pages.

...create an Android mobile optical reader application using OpenCV for image filtering. The main purpose of the application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be developed for Android. The gene...

...authority databases for certain information sets. - Specific focus is needed on planning submissions and permissions that require BNG (biodiversity net gain credits)(the leads). The information is to be taken from Local Planning Authority official websites (publicly available information and no logins required). An in-depth knowledge of planning submissions and permissions and BNG is NOT needed. What is however required is accurate information to be taken from those websites and converted into a database for us. - This work can be done remotely and only requires a computer and access to the internet. - The geographical focus of the UK planning authorities we require information from will be provided to you in a prioritised list This is...

I need a meticulous data entry specialist to help me clean and format a large set of digital documents. Key Responsibilities: - Sorting and organizing data effectively. - Removing any duplicates and errors present in the data. The ideal candidate should be familiar with data entry and have a keen eye for detail. Experience in data cleaning and formatting would be a plus. Time management is crucial for this project.