Conditional formatting google sheets based on another cellεργασίες

I'm keen on improving my website's search engine rankings on Google, particularly through keyword optimization. Here's what I'm hoping to get out of this project: - Significantly improved visibility on Google's Search Engine Results Pages (SERPs) - Expert analysis and utilization of keywords to boost my website's ranking - Guidelines on incorporating these keywords organically into the existing website content The ideal freelancer for this project should have: - Extensive SEO expertise, particularly in keyword optimization - A solid understanding of Google's algorithm and ranking system - Proven track record of increasing website ranking on Google Please note that this project is not about driving immed...

I need a talented artist who can paint a landscape on a large ceramic piece, approximately 3 ft. square. The painting will be displayed in our entry courtyard. - The desired theme for the painting is a landscape, specifically a scenery similar to the Grand Staircase found in the southwest United States. - The artist is expected to have experience painting on ceramics, and have a good understanding of landscape art. - Ideally, the freelancer should be able to capture the essence and beauty of the Grand Staircase in their work.

I am seeking a skilled data miner for a project involving business data extraction from the Yellow Pages. Specifically, I am interested in the category of 'Equipment Hire in Australia'. The scope of the data to be extracted includes: - Business Names - Phone Numbers - Physical Addresses - Email Addresses This project would be ideal for freelancers who have experience in data mining, data extraction, scraping Yellow Pages, and processing information through Python, R, or a similar language. Knowledge of the business environment in Australia would be a plus. Please note that accuracy is paramount; I need the completed dataset to be as error-free as possible. Looking forward to reviewing your bids.

Looking for an experienced Google Ads campaign manager to leverage my website's existing Ads account. The primary goal of the campaign will be to increase website traffic Ideal candidate must have: - Extensive experience in effectively running Google Ads campaigns - Proven track record of increasing website traffic - Strong understanding of marketing strategies for engaging young adults (18-25 population segment) - Outstanding analytical skills to interpret AdWords data and make necessary adjustments for optimal results. I welcome your expertise and suggestions on how to achieve the desired goals.

I'm seeking the expertise of a creative professional to revamp my existing PowerPoint presentations into engaging Google Slides designed specifically for high school students. Key Tasks: - Conversion of current slides into Google Slides. - Enhancement of slides aesthetics with vibrant colors. - Incorporation of infographics and images relevant to the subject matter. - Retention of original content while transforming the text layout for better readability and impact. Ideal Candidate: - Proficient in Google Slides - Experience in Graphic Design. - Ability to create engaging infographics - Experience in educational content is a plus. The focus of this project is to improve the design and visual appeal of the slides without altering the essential details. Needs...

...duration and include revenue projections, expense breakdown, profit margins, income statements, balance sheets, cash flow statements, and key financial ratios. Key requirements: - Create a financial model for a 3-year duration - Include revenue projections, expense breakdown, and profit margins - Develop income statements, balance sheets, and cash flow statements - Calculate key financial ratios The expense breakdown should be moderate, covering major categories with some subcategories. Ideal skills and experience for this job include: - Proven experience in financial modeling, especially for service-based businesses - Proficiency in creating detailed income statements, balance sheets, and cash flow statements - Familiarity with key financial ratios and t...

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

...Your responsibilities will include updating the colors and fonts, improving the layout and organization, and revamping the logo. Since I haven't decided on a specific color scheme or fonts yet, your input and suggestions would be valuable for me. Key responsibilities: - Revise the color scheme and fonts. - Improve layout and organization for optimal user experience. - Design a fresh and appealing logo. - Inject interactive elements to engage users. I'm eager to see your creative designs, and while I don't have specific websites for design inspiration, I'm open to your suggestions. Please note that I only need HTML and any style sheets or JS files. Ideal candidate: - Experience in web design and UI/UX. - Strong graphic design skills, particularly ...

Hi! Your job 1. Go to a website (url in brief) every day to every other day 2. On that website click a link to open another website. This website is NOT live/active yet. 3. Open the list of names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the email is sent, change body of email and when the scraping starts/stops as well as frequency (daily or every other day).

I'm seeking an expert in UI/UX design to enhance a web-based inventory management software. The design should emphasize on visually representing inventory. This should make it simple and intuitive to understand the inventory status at a glance. Freelancers bidding should ideally have: - Proven experience in designing for web-based platforms. - Knowledge and practice in making information accessible visually for easy comprehension. - Past work involving inventory management software or similar would be advantageous.

**Project Overview:** We're looking to set up a Zoho Portal that allows users to create emails using their custom domain and integrate them with Zoho Sheets. The goal is to replicate the functionality of an existing Google Apps Script that forwards emails to Google Sheets. The freelancer will be responsible for configuring the Zoho Portal, setting up email forwarding, and integrating Zoho Sheets to achieve seamless email-to-sheet automation. **Prerequisites:** - Access to Zoho Mail and Zoho Sheet. - A custom domain configured with Zoho Mail. - Basic knowledge of Zoho Mail, Zoho Sheet, and email forwarding. **Scope of Work:** 1. **Zoho Portal Setup:** - Configure the Zoho Portal to enable email creation using the custom domain. - Ensure pro...

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry and copying

I am seeking an expert in Google Display Ads to help me drive traffic to my apparel website, targeting professionals aged 25-65. The primary goal of the traffic generated should be to increase sales. Key requirements include: - Proficient in Google Display Ads: You should have a proven track record of setting up and managing these ads effectively. - Understanding of Audience Targeting: Experience in targeting specific demographics, in this case professionals aged 25-65 - Conversion Optimization: You should be able to optimize the ad campaign to make sure the traffic generated translates into actual sales.

I'm experiencing an urgent situation with my Google business account. Every time I try to upload product images, they are being rejected by Google but I'm not receiving any specific reason or error message. I need help to resolve this issue immediately. Ideal skills and experience for this job include: - Experience working with Google business profiles and photo uploading - Familiarity with common issues related to image rejections - Ability to troubleshoot and resolve technical issues quickly and efficiently I would appreciate it if this could be resolved as soon as possible. Thank you.

I am looking for an expert in Google Ads to help set up ADX MA ads for my project. The primary objective of these ads is for AD MANAGER. Specifically, I'm in need of help when it comes to implementing ad tags on my website. Your skills and experience should encompass: - Proficiency in Google Ads platform - Understanding of ADX MA and its application - Experience in ad tag implementation - Knowledge in Display Ads, Search Ads, and Video Ads strategy I am aiming for a smooth, effective project execution. As such, I need someone focused, detail-oriented, and experienced in the field. Reach out if you believe you're the perfect fit.

I am seeking a writer to craft a compelling and concise essay of less than 500 words. The topic was not specified but the style should be compliant with APA. Skills & Experience Required: - Anyone who has cleared writing creek test. - no AI-generated content - no grammar mistakes - no plagiarism - basic essay structure - word count is 275-300 words - APA style formatting is required if you use any sources.

its says site compromised and dissapproved. I have scanned the site and its fine. You have to work on any desk

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

I'm seeking a proficient writer to develop a less than 500-word essay. Unfortunately, I haven't specified a particular topic for the essay; I will provide this later. The project needs to be del...this later. The project needs to be delivered in the APA format. Key Requirements: Writing assignment - no AI-generated content - no grammar mistakes - no plagiarism - basic essay structure - word count is 275-300 words - APA style formatting is required if you use any sources. Ideal candidates may already have an academic writing background and should be comfortable writing across a variety of potential topics. You'll have the freedom to craft the essay creatively within the word limit. It's crucial that the document follows the guidelines of APA formatting....

Hi there, I need an expert in Python. I have a python program which is working to forward messages from a group to another. What I want is to add few filteration.

I'm looking for a capable developer to create an auto delivery bot that will be hosted on a website and used for delivering in-game items and currency for Roblox. Key Responsibilities: - Develop a fully functional auto delivery bot that integrates seamlessly with a website. - Ensure the bot is capable of delivering in-game items and currency for Roblox. Ideal Skills and Experience: - Proficiency in website development and integration. - Experience in creating automated bots or systems. - Familiarity with Roblox game mechanics and trading systems. - Strong communication skills and ability to work collaboratively.

We are looking for a seasoned specialist committed to elevating our online Visibility. The underlying aim is to encompass the enhancement of website traffic, and search rankings with an effective SEO strategy. Please only apply if you have experience in SEO Copywriting and are ready to start work immediately. Ideal Candidate Traits: - Proficient in Keyword Research/Analysis - Skilled at On-page SEO Optimization - Know The Helpful Content Optimization - Demonstrable success in Increasing Website Traffic - Proven track record in Improving Search Rankings - Highly efficient and able to start immediately. To Apply: Please append links to examples of past work that mirror the proficiency I seek. Let's take our digital footprint to the next level, together.

...editable check-in sheet for my fitness clients, to be created in Google Sheets. - The sheet should contain sections for clients' names, contact information, weight, body measurements, workout details, and progress. - Each client should have a separate sheet, making it easier to manage and update the data. - The sheet should include formulas for tracking workout improvements, such as increased weights or reps. - Each sheet should be able to be progressed for approximately 8 to 10 weeks and should be editable week to week. - Ideally this sheet would be a template that I can use over and over again with clients. The ideal candidate for this job should have: - A good understanding of fitness tracking - Proficiency in Google Sheets, including formulas ...

Project Brief: In this project, will be developing an application to sense, share and control another application on a nearby node. The application can be mobile, web or desktop. The application is required to: 1. Sense a nearby node. When a node comes within the communication range and also when it moves out from this range. An indication should be there when a node is sensed or moved away. 2. Share some content. It can be some message, file, chat etc. 3. Control minimum one feature of the remote node e.g., volume, brightness, wallpaper etc. Project Requirements 1. The deadline for the project is: 10-May-2024. a. Report: It should include: ii. Name of the application iii. Application’s purpose iv. Explanation of its functionality from the perspective of ad hoc and sen...

Παρακαλούμε Κάνε Εγγραφή ή Κάνε Είσοδο για να δεις λεπτομέρειες.

Greetings. I am in need of some assistance with branding for a residential remodeling company located in the US National Capital Region. Key Tasks: - Formatting of Logo (existing logo available) - to be made available for use with different color backgrounds and sizes for use in print (from business cards, door hangers to yard signs) as well as web base applications (FAVicon, FB, website, etc.) - Design standard sized business card template (inclusive of logo) - Design template for door hangers (size 3.5 x 8.5 inches) inclusive of logo and stock images Application Requirements: - Please showcase your previous relevant work in the application to give me a clear idea of your capabilities. Looking forward to witnessing some creative works! Ideal candidates should have experience in...

...troubleshoot the conversion tracking on my Google Ads. I have successfully set up tracking for my lead submission conversions, managed through a Forminator form, but it seems to have stopped working after the initial recording. Key tasks and requirements: - Analyze the current GTM setup to identify the root cause of the issue. - Reconfigure GTM as needed to ensure accurate and consistent conversion tracking. - Test the tracking to verify that it's accurately recording the conversions. - Provide insights and recommendations on how to maintain and troubleshoot the tracking in the future. It's crucial for me to get this fixed as soon as possible, so please only reach out if you're experienced in GTM and have a proven track record of solving similar is...

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm looking for an experienced digital marketer who can strategize and execute a Google campaign. Key Objectives: - Increasing website traffic - Generating leads - Increasing brand awareness Target Audience: - Location-based, so expertise in geo-targeting is a must. Ideal skills and experience: - Proficiency in Google Ads - Extensive experience in campaign strategies - Proven track record in achieving website traffic, lead generation, and brand awareness goals - Expertise in location-based advertising.

...of enhancing the vehicle's overall performance. Key Areas: - Durability and Strength: The rim should be able to withstand the pressures of regular road use, ensuring longevity and minimal maintenance. - Weight Reduction: A crucial aspect of the design is to minimize the weight of the rim, contributing to improved handling and maneuverability. - Heat Dissipation: Effective heat dissipation is another essential feature to be incorporated into the design, potentially leading to enhanced braking performance. The ideal candidate should have a strong background in mechanical engineering or product design, with a proven track record in alloy rim development. Previous experience with vehicle components would be highly beneficial, especially in the sedan category. A creative and in...

I need a meticulous researcher to compile data from LinkedIn and Google, resulting in a thorough Google Doc. This task involves gathering the following specifics: Contact details, Company information, and Job titles. It also includes the LinkedIn Profile URLs of the relevant associates. The final document should contain around 100 to 500 entries. Ideal candidates possess conversance with LinkedIn's platform, effective Google search strategies, and proficiency in Google Docs. Excellent organization skills are also expected. Your meticulousness will help in ensuring that accurate, updated data are reported. Let your attention to detail shine through and exceed expectations in this task. I will give you a URL that contains approximately 50 records that hav...

I'm currently in need of a LaTeX specialist who can help me in designing templates for my midterm review and exams for an R programming cla...would appreciate a level of consistency in the templates. I also need the freelancer to be able to troubleshoot any issues that may arise with the templates. This includes: - Ensuring all formatting is correct and displays properly - Fixing any errors that I may not be able to solve on my own Ideal skills and experience for this job include: - Strong understanding of LaTeX and associated packages - Experience placing R programming in Latex - Experience in template design, particularly for academic material - Excellent troubleshooting skills - Ability to work to a deadline and communicate effectively on progress. Looking...

Google Ads advertiser required to run specific ads as agency

It's a restaurant food delivery app. Back-end admin in laravel and app in flutter. The following issues need to fix: 1. Increase notification volume in admin and notification sound is not happening once admin works in another tab in his system. 2. Invoice printout is not legible. this should be corrected. 3. Create Kitchen token. There will be only 3 fields, Customer name, item ordered & quantity. All this inputs can be taken from invoice.

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

I require a meticulous freelancer with efficiency in Google Spreadsheets for a substantial data entry project. The data involves text, numeric, and image content. Key responsibilities: - Entering and arranging more than 500 data entries that are composed of text, numeric and image data. - Ensuring accuracy and organization in the Google Sheets platform. Desired Skills: - Proficiency in working with Google Spreadsheets - Strong organizational and analytical skills - Attention to detail - Previous experience in data entry Please note, it is crucial that all data entered is accurate and reliable, thus prior experience with meticulous data entry work is desired.

...If interested, please message me and I'll provide a fully subscripted tester account for you. My website is a subscription-based practice exam platform. It offers 3 subjects: Mathematical Reasoning, Thinking Skills, Reading. Practice exam: Students receive 40 minutes to complete exams which are made up of x multiple-choice questions. Reading has 30 questions, Thinking skills has 40 questions, Mathematical Reasoning has 40 questions. Mock exam: Students complete 3 practice exams in a row - 1 Reading, 1 Thinking Skills, and 1 Mathematical Reasoning. Functionalities include ranking students against one another, timing, question categories, etc. Bugs to target: - Sometimes, a user starts an exam, only to find that some questions are already answered for them, around

I run an e-commerce website on WordPress and one of its major traffic sources is Google. I need a professional that can help me remove the price snippet from Google search results. Key Points: - The price snippet (the price of the product) is appearing on Google search results related to my website. - I need it to be removed as it affects the click-through rate and I want users to visit the website to check prices. - The website is built on WordPress, so experience with this platform is essential as you'll be working directly with the website's backend to remove this snippet. You must have experience in PHP and understand Wordpress framework. - Familiarity with how Google indexes and displays website information is also key to e...

...might add support for other input formats as well in the future). Next, once we have the text available, it should split the text based on the lines. It can split on the full stop character. And then every line must be sequentially given to a ML model. This would be a text classification huggingface model, which can be instantiated via this code: from transformers import pipeline pipe = pipeline("text-classification", model="legal-text-classification/IndianLegalBERT") Feel free to explore the above model yourself. It will give you 15 labels with different scores. If the score of the top scoring label is greater than 0.8, then it must highlight that line on the webpage with the color associated with that label. And the model must ...

I'm looking for a professional with high proficiency in Photoshop, who has sophisticated understanding of textual content handling. You need to be able to achieve two significant tasks: 1. Text Overhaul: - Entire sections of the document need rewriting. - Formatting and style changes are also required. 2. Image Amendment: - Essential changes to the images are also required, to match stylistically with the text alterations. Ideally, you should have prior experience in document design and complex photoshop tasks. This job is not for a novice but for someone who appreciates the challenge of a complete visual and textual transformation.

I am seeking a professional capable of setting up and managing Google Search Ads with the goal of boosting product sales. The ideal freelancer will have experience in: - Google Ads: Expertise in setting up and managing ad campaigns on Google Search. - Conversion Optimization: Proven record of increasing sales through Google Ads. - Keyword Targeting: Ability to refine and optimize existing keyword lists. - Market Research: Understanding of the market and the ability to suggest additional keywords for better results. Prior experience in e-commerce or similar product-focused sectors will be considered an advantage. The successful candidate will be expected to collaborate closely with me and provide regular reports on the performance of the ads.

...should be designed to accommodate various features. These include user registration and profiles, private messaging between users, and invoice generation and payment processing. - Additional Features: The platform will also support image and video uploads, as well as feature a news feed and timeline. The website is intended to serve as a platform for users to post content, interact with one another, and engage in agreements that can be followed up with invoicing for services rendered. Ideal candidates should have a proven track record of developing social networking sites, with a deep understanding of user experience and payment processing integration. Experience in handling image/video uploads and news feed/timeline features is essential. A strong portfolio that showcases s...

...augmented reality (AR) application for both iOS and Android. Key Features: - The app needs to have interactive quizzes to engage the users and aid in their learning process. - 3D object manipulation is crucial for the application to provide a hands-on experience, making it more immersive and beneficial for the users. - Real-time information overlay is another essential feature that will enhance the user experience and provide additional context to the subjects being taught. Subject and Focus: The augmented reality application will be focused on the subject of Science. It should be designed in a way that makes learning science fun, interactive, and easy to comprehend for its users. Ideal Skills and Experience: - Proficient in Unity and AR development. - Experienc...

...seeking an experienced web developer with a strong background in PHP and CakePHP 2.x framework to integrate Google Sign-In into our existing web application. Our application currently follows a multi-step flow and uses MVC architecture. The integration must be seamless and maintain the current workflow. Objectives: Google Sign-In Integration: Implement Google Sign-In to allow users to authenticate using their Google accounts. User Redirects: After successful authentication, users should be redirected to the 'typeform11' page as part of our existing workflow. User Data Retrieval: Retrieve and display the user's Google account information including profile picture, email address, and name on the redirected page. Error Handling: Pro...

As a forward-thinking service provider, I am expanding my offering to include Google Ads Management for my growing client base, currently centred around local businesses. I am seeking a proactive and seasoned professional to play a central role in this development. The successful candidate should proficiently handle: - Keyword research and analysis, utilising industry and local trends - Ad copywriting and testing, ensuring impactful and engaging content - Campaign optimization, using data-driven insights to maximize results Previous experience managing Google Ads campaigns is imperative, but experience specifically within the context of local businesses will be particularly advantageous. I am looking for someone who can join me in this venture from ground zero, wit...

I need an expert to further optimize my existing CNN model that currently has an accuracy rate of over 80%. Despite the high performance, I believe there's room fo...Extensive experience with Convolutional Neural Networks (CNNs) * Proficiency with text data processing * Track record of improving the accuracy of machine learning models Job Scope: * Review the current model and identify potential areas for improvement * Implement strategies to increase training speed and minimize overfitting * Improve the model's overall accuracy * Maintain detailed documentation on the steps taken and their impacts Despite the model's high initial accuracy, I'm ambitious about reaching even higher stats. If you're a guru at improving CNN models, especially those handling ...

I'm in need of an experienced developer to create a chatbot for a business, to be implemented on a website. The primary functions I need the bot to handle include appointment scheduling, providing detailed information on services, and answering frequently asked questions. Key Requirements: - The chatbot should be designed to specifically function on a website interface. Experience with Voiceflow or similar chatbot development tools is a must. - The bot is expected to collect and store user data in a Googlesheet at this point in time. - It should be able to handle appointment scheduling, providing information on services, and responding effectively to common queries. - The bot should be able to collect specific user data, specifically Name, Email Address an...

As the owner of an agency, I'm seeking an experienced Google Ads manager who can take over the management of my clients' ad accounts. Primary Goals: - Primarily, the goal is to generate leads for the clients. Your Responsibilities: - Set up and manage Google Ads campaigns for multiple clients. - Monitor performance and adjust bids and budgets as necessary. - Generate reports outlining campaign performance. - landing page optimization Skills and Experience: - Proven track record in managing successful Google Ads campaigns - Mastery in strategizing paid campaigns aimed at lead generation. - Strong analytical skills to assess and adjust campaign strategies. - Excellent reporting skills with a keen attention to detail.

I am looking for a proficient typist who can handle copy typing projects from PDF format, ...PDF format, specifically text-only copies. This task ideally suits beginners who exhibit accuracy, speed, and efficiency in their work. Key Tasks: - Convert a PDF (with text only) into a word document. - Keep the layout of the text simple without the need for detailed formatting. Skills and Experience: - Fast, efficient, and accurate typing skills. - Experience in data entry, specifically from PDF to Word conversions. - Attention to accuracy and detail. - Ability to follow clear instructions regarding layout and formatting. The final document should be a flawlessly typed-text with a simple layout and delivered in PDF format. Please keep in mind that neatness and accuracy are paramo...

I need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cleaning with experience in standardizing the formatting of textual content. - The data is currently stored in plain text files, so experience working with this type of data storage is necessary.