Conditional formatting google sheets based on another cell jobs

I'm after a creative and experienced designer to create a fun and whimsical design for 5th grade graduation t-shirts. Key Requirements: - Design needs to have the green EDNA logo with 68 names written either in the green hors (or another exciting hors) or in the EDNA letters, or in the negative space. needs to include 2023-24 (in some format) Ideal Candidate: - Proven experience in graphic design, specifically with t-shirt designs - Ability to deliver a design that is both fun and rustic - Attention to detail, specifically when incorporating the school emblem and student names. Be ready to present past work samples as proof of experience. I'm looking for a captivating design that the students will remember forever. Cannot wait to see your creative efforts.

I need an expert to design an effective Business plan offering memorandum ...investors and aim to provide a clear understanding of our business model and financial health. Key Requirements - Business plan -Vacation rental industry not a must - Proven experience in drafting offering memorandums and business plans, preferably within the real estate sector. - Strong understanding of financial data presentation, particularly income statements, cash flow statements, and balance sheets. - Ability to design a document that is engaging and convincing to potential investors. The perfect candidate will demonstrate impeccable attention to detail, a solid understanding of the real estate and investment sector, and experience in financial document preparation. I look forward to receiving ...

I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

...photos. Right now the website allows the client to publish the product in a category (Example: Cards) and within this there are some associated subcategories (Example: Pokemon), we need to add another level of subcategory (Example: Pikachu SV4 2024). The scheme would look like this (Example: Cards->Pokemon->Pikachu SV4 2024). The main category already allows the creation of subcategories, it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a second subcategory level linked to another subcategory. 2nd. In that second level of subcategory, at the top there appears an image of the category, a descriptive text and a graph that shows the evolution ...

...store into the appropriate categories and collections. Additionally, I need someone who is experienced with Shopify and Google Merchant Center to fix the errors that are currently preventing my listings from going live. Key tasks include: - Organizing 15,000+ products into proper categories and collections according to a provided .doc file. - Fixing errors on Google Merchant Center to ensure existing listings go live. - Making necessary adjustments to the Shopify theme, including changes in colors and layouts, for a more appealing store design. The ideal candidate should have: - Extensive experience with Shopify store management and organization. - Proficiency in Google Merchant Center and fixing product listing errors. - A good eye for design, particularly...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that...

I have a substantial amount of content, which needs to be typed into a new Microsoft Word document. The document is a creation task from scratch, rather than editing or formatting. It is large in size, containing over 1000 words. Requirements: - Typing a large document (more than 1000 words) into Microsoft Word. - Ensuring the text is free from errors such as typos and grammatical mistakes. The ideal freelancer should: - Have excellent typing speed and accuracy. - Be proficient in Microsoft Word. - Be detail-oriented and able to proofread the text for any errors.

...physical products. I'm looking to have the shipping costs calculated based on the distance to the delivery address, using postal/ZIP codes as the metric. Key Requirements: - WooCommerce Setup: Need someone who is well-versed in setting up eCommerce stores with WooCommerce. - Shipping Configuration: Experience in configuring shipping settings within WooCommerce, particularly for distance-based calculations. - Geolocation Skills: Proficiency in working with postal/ZIP codes to determine distances for shipping cost calculation. - Problem-Solving: Ability to troubleshoot and resolve any potential issues that may arise during the project. Your primary task will involve implementing a system that accurately calculates shipping costs based on the dista...

I'm seeking an experienced Wikipedia writer to set up a personal profile. The source material available for the profile is moderate, so it will require some research and accurate information gathering. The project will include only setting up the page, without the need for regular updates or monitoring. Ideal skills would include: - Extensive experience in Wikipedia page creation and formatting - Proven research skills - Capacity to work with moderate source material to create a comprehensive profile.

I'm looking for a PHP expert to handle several minor tasks on my website. Key Responsibilities: - Implementing links from images to other pages. - Making the odd amend to the site - updating google maps code The work is quite straightforward and doesn't involve any major development. It's more about making small changes and ensuring the website works smoothly. Ideal Skills: - Strong PHP development skills. - Proficiency in HTML, CSS, and JavaScript. - Experience with integrating links and implementing simple changes. - Ability to understand existing code and make small tweaks. If you're a PHP developer who can quickly and efficiently manage these minor tasks, I'd love to hear from you. This may lead to another task too. Thank you.

I'm in need of a talented game developer to create a mobile game for both iOS and Android, in the grinding genre. I will provide map converters and all necessary assets for the game. Key Features: - Multiplayer Functionality: The game should have the capability for players to interact with each other in-game. - Leaderboards: Implement a system for players to compare their achievements and progress. - In-app Purchases: Include a functioning in-game store where players can purchase virtual goods. As the project is mainly about implementing the provided mechanics, I'm looking for someone with experience in online game development, particularly in the mobile sector. In addition, knowledge of grinding game mechanics will be helpful. An ideal candidate would have experience with imp...

The most emblematic activities to do. The popup login action will be added to the header and from the home page button. Next buttons will also be hidden in lessons.

...font styles, tables, images, and page numbering are all maintained. Key Requirements: - Preserving font styles and formatting: It's important that the text in the Word document appears exactly as it does in the PDF. - Keeping tables and images intact: The tables and images should be accurately reproduced and remain in their original positions. - Maintaining page numbering and headers/footers: The Word document should mirror the PDF in terms of its pagination and any header or footer content. Evaluation: - Accuracy of text conversion: I will compare the text of the original PDF with the Word document to ensure that there are no errors or omissions. - Layout and formatting match with the original PDF: The Word document should be a near-identical replica of the PDF in...

...transfer as a payment method on my existing website. Currently, my site only supports PayPal and I want to add another layer of customer convenience by allowing bank transfers. I need to be able to sell theater tickets, so an interactive sitting map should be available. While I haven’t decided yet on a specific bank or service for processing these transactions, I am open to suggestions. If you have prior experience with multiple processors, that would be a significant advantage. Ideal skills and experience: - Proven background in E-commerce website development - Knowledge of various payment processors - Understanding of safe and secure payment gateways - Ability to integrate new payment methods without disruption of site performance Please base your bid...

I am in need of an Articulate Storyline expert to create an exciting, interactive game-based learning module targeted at adults. Requirements: - The module should have a moderate level of interactivity, including quizzes and drag-and-drop elements - The content must be engaging and challenging for adult learners, it should be both informative and entertaining - Attention to detail is crucial, the module should flow well and be free from technical errors - You are encouraged to bring creativity and originality to the project, it should not be a standard, uninspired e-learning module Ideal Skills: - Expertise in Articulate Storyline is paramount - Experience in developing game-based learning modules is a major plus - Understanding of adult learning principles and ...

I'm seeking a savvy developer to create a 1D barcode (UPC, EAN) inventory management system. This should then be integrated with an existing product management system. Key requirements: - Design and develop a user-friendly barcode inventory control system - Experience with 1D barcodes, preferably UPC and EAN - Capability to integrate with existing product management software The main users of this system will be store staff members. Therefore, it should be easy to navigate, and seamless in functionality to support a fast-paced retail environment. Expected expertise: - Proven experience in building similar inventory management systems - Proficiency in working with 1D barcode technology - Expertise in software integration - Solid understanding of user interface for non-technical ...

I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to inclu...WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service could be c...

Develop a chatbot with a web ch...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 google cloud in a Docker container, written in Python, and include comprehensi...

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.

...should be capable of 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 d...

My company has a logo, recently I noticed a very nice brush effect on another company's logo that I want to apply to my current one. I have the reference so it should be very quick and straight forward . thank you, the reference is attached below

This is for my College final project, I need to develop a simulation of AI based threat detection.

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 Skills: - Profic...- 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 if it...

We are starting a project to develop a QR code payment application called "Metropol Pay" that will run on the Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and...

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.

Please Sign Up or Login to see details.

Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace

I'm looking for a couple of strong individuals who can disassemble two platform beds in one room, move them to another on the same floor, and reassemble them. - **Task**: Disassemble, move, and reassemble 2 platform beds. - **Beds**: Platform beds. - **Accessibility**: No concerns, rooms are easily accessible. - **Equipment**: The beds are heavy, and the job will require at least two people. - **Timeline**: The task should be quick, but precision is key so wood doesn’t get damaged Ideal candidates for this job should have experience with furniture disassembly and reassembly, good physical strength, and timeliness in their work.

Product Description: - FamPe is a platform that enables viewers to interact with their influencers through messages and monetary contributions. Adding a monetary contribution prioritizes and highlights their comments/messages. Brand Name: FamPe Brand Values:- - Innovation - Reliability - Efficiency - User-Friendly Logo Style Preferences:- - Audience: YouTube streamers and viewers, ages 15-45, worldwide demographic - Type: Wordmark logo, modern and minimalist - Feel: Exclusive, Professional, trustworthy, cutting-edge - Color Palette: Primary: #EC6A5E, #5156D4, Accent: #EC6A5E (given color palette is preferable, can use any other if you wish) - Typography: Clean and modern sans-serif fonts; should be easy to read - Logo Elements: An element of exclusivity such as a star icon, spark, crow...

...be 24-pages long, a5 sized (6 a4 sheets folded in half to A5 size). - The design style should be traditional and elegant. Content: - I'm keen to include information on local property values in the booklet. This is crucial for potential clients who are interested in the real-estate market in our locality. Skills and Experience: - I expect the designer to have experience in creating similarly styled elegant and traditional designs. - A good understanding of the real-estate market or experience in designing for estate agencies would be a plus. - The designer should be able to translate information on local property values into a visually appealing and engaging format. If you think you're up to the task, I'm eager to view your portfolio and hear you...

I require a capable developer to create a new Python module from Wazuh server using C programming. This module should retain the following functionalities from the original: - Agent registration - Remote configuration - Log receiving A deep understanding of TLS and SHA technologies is a must.

...the final one is loaded. I need one font instantly loaded rather than how it appears currently. I’m happy for this to be a different font (such as one that sits on Google), if it will load instantly, however I want the font still looking good, Lead Form capture not working The form capture isn’t working correctly. Originally it was sending through to my email address when someone filled out a form, however I had my email moved from GoDaddy to Google and it hasn’t worked since. Additionally the form capture doesn’t have the capability to actually see the responses within WordPress. I am happy to change to a different form if another is more suitable and providing the cost is minimal. Free cookie consent loaded I want a cookie conse...

I am in need of professional help to bring structure and uniformity to my extensive Word document, which is 60 pages. The scope of work will include: - Text...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 alongside qual...

I'm looking for a Google Ads specialist to help drive website traffic effectively and efficiently. Key Requirements: - Proficient in Google Ads: You should have a strong understanding of the platform's features, including keyword targeting, ad placement, and budget management. - Experience in Website Traffic Generation: You should have a proven track record of increasing website traffic through Google Ads campaigns. - Target Audience Knowledge: An understanding of the professional demographic (aged 25-40) is essential. You should be able to tailor ad content to resonate with this group. Your primary goal will be to increase website traffic amongst professionals aged 25-40. I'm looking for a professional who can effectively manage and optimize the camp...

I'm seeking a design team to handle our company's ongoing design needs on a monthly retainer basis. Our requirements encompass Graphic, Web, and UI/UX design. Key responsibilities: - Crafting new designs from scratch: You must have a strong understanding of current design trends and best practices, and the ability to create fresh, original designs that align with our brand's identity. - Updating existing designs: You will also be responsible for enhancing and refreshing our current designs to ensure consistency and relevance in the market. I am looking for a team that can accommodate the following: - Daily deliverables: We anticipate requiring new designs on a daily basis, hence your team must be able to commit to this frequency. - High quality work: Our exp...

I'm seeking an experienced CAD jewelry designer for custom-made jewelry pieces. Key tasks include: * CAD designs for a three different types of jewelry: rings, necklaces, and bracelets. * All designs will need to incorporate a mixture of materials such as gold, silver, and gemstones. The ideal candidate would have: * Proficiency in CAD software specifically for jewelry design. * Familiarity in using diverse materials such as gold, silver, and gemstones. * Experience in creating varied forms of jewelry like rings, necklaces, and bracelets. Your portfolio displaying your previous work in CAD jewelry design will be highly favored in the selection process.

I am looking for an expert proficient in handling Outlook PST files and cloud storage services to relocate my PST folder from OneDrive to Google Drive. - I use Microsoft Outlook for email and have been encountering storage space limitations with my current setup. - The size of the PST file is between 2GB and 10GB. - The main goal of this project is to alleviate the storage issue while ensuring a seamless transition of my email data to Google Drive. Ideal candidates should have: - Strong experience with Microsoft Outlook, including handling and migrating PST files. - Proficient knowledge of both OneDrive and Google Drive to efficiently move the PST folder. - A clear understanding of data migration best practices to ensure all data is securely transitioned without ...

I need an experienced web developer who can create an e-commerce website with a professional and corporate aesthetic, targeted at a middle-aged audience. The website needs to feature embedded subscription services, via API integration, from another website ("White Label"). Key requirements: - Design, create and host a professional Subscription site. - Integrate subscription services via API from another service provider. - The website should appeal to a middle-aged demographic. Ideal skills and experiences: - Proven experience in e-commerce web development and design. - Expertise in API integrations. - A strong understanding of target markets and designing with them in mind.

...seeking a skilled freelancer to help us capture high-quality screenshots and record demonstration videos of our mobile app for both Google Play and the Apple App Store. The freelancer should have access to both Android and iOS devices to perform the tasks effectively. Requirements: Screenshots: Android: Capture 10 high-quality screenshots showcasing all key functionalities of the app. iOS: Capture 10 high-quality screenshots for each device size: iPhone 6.7" iPhone 6.5" iPhone 5.5" iPad 13" iPad 12.9" Screenshots must be taken directly from each device; resizing from other screenshots is not acceptable. Ensure all screenshots comply with the guidelines of both Google Play and the Apple App Store. Screenshots should highlight the main features and...

Hello, I am looking for a Google Ads expert to assist me with the following tasks: 1. Set up Google Analytics and Google Tracking. 2. Launch and manage a single Google Ads campaign. 3. Optimize the campaign for better performance. My monthly budget for this project is $100. If you are interested and believe you can meet these requirements, please get in touch. Thank you, Azmi

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.

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL database that requires careful handlin...

I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to inclu...WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service could be c...

...developer to create a web-based basic arithmetic calculator. Primary Functions: - The calculator should perform basic arithmetic operations such as addition, subtraction, multiplication, and division. Key Features: - The calculator should have a clean and user-friendly interface. - A history feature is optional, if you can integrate it seamlessly without compromising the simplicity of the calculator, that would be a plus. Ideal Skills: - Proficient in web development, particularly in developing interactive and user-friendly interfaces. - Prior experience in building calculators or similar tools is a big plus. - Strong understanding of basic arithmetic operations and their implementation in code. This is a great opportunity to showcase your web development skills on a...

...try-on utility applicable to all categories of attire, from tops to bottoms. This platform enhancement has the primary purpose of refining the online shopping journey for our users, fostering a more immersive, engaging, and satisfying user experience. Ideal candidates will have a strong background in: - Web development particularly in eCommerce platforms - Prior experience implementing virtual try-on or similar augmented reality features This development project requires: - Modification of the existing product pages to integrate the try-on feature - Ensuring the feature is user-friendly, intuitive and compatible across various devices - Testing and bug fixing to guarantee smooth operation before site-wide deployment Your task will be to deliver a fully functiona...

SEO Audit tool need to make using google lighthouse Hello, 1, We want to make an SEO audit tool, by the help of integrating the google lighthouse to generate an SEO Audit report. Here is a link to how you can do it. Here is an example how these people have integrated and using google lighthouse to generate reports. We need exactly the same. 2, need an admin panel where admin can add or import the list of the website url,and website owner name , number and email address. So report can generated by the system and keep sending the email pdf report to the owner of the website like its work in front side for this site

I'm in need of a Bulgarian resident who can assist me in obtaining a certificate of fiscal residence from the Bulgarian tax office for my company. Your role: - You don't need to be the com...resident who can assist me in obtaining a certificate of fiscal residence from the Bulgarian tax office for my company. Your role: - You don't need to be the company owner, but you should be living in Bulgaria. - I don't have the legal authorization to obtain the certificate on behalf of the company, so you should have experience in navigating this process. - The certificate will be used for tax purposes in another country Ideal Skills and Experience: - Residency in Bulgaria. - Legal expertise in obtaining documents on behalf of a company. - A good understa...

Google Business Profile We are looking for a Growth Manager who can grow us with his work and help in taking your business forward.

I am in need of a Flutter-based image editing tool that can perform specific functions. The main requirements for the project are: - Development of a tool that can work seamlessly on both Android and iOS platforms. - The tool must be capable of copying a part of an image and pasting it in another location. - It should support different image formats, ensuring compatibility with various image types. The user interface for the tool is expected to be: - Interactive: The tool should engage the users and provide smooth navigation. Ideal skills for this project include proficiency with Flutter, knowledge of image editing functionalities, and experience in developing user-friendly interfaces. Successful completion of this project will require a thorough understanding of t...