Conditional formatting google sheets based on another cellроботи

Табличка буде використовуватись для аналізу конкурентів ринку. Вона має бути зручною для ведення, зі зрозумілим звітом у вигляді графіків на основному дашборді. Показників в різних категоріях які вона має рахувати більше 30, терміни, фінанси, порівняння, відсотки, категорії, середні значення. Чекаю Ваших пропозицій стосовно вартості

...(attached video), where there will be a button with a suggestion to switch to another browser. When clicked, call a dialog box (system window) and redirect the user to the selected browser. If possible, make it so that only chrome was from the options. Target audience - Android, iPhone is not considered now We want to place a link to the page in tiktok, but need to redirect the user to a third-party browser and do it with a dialog box, other methods as far as I know do not work I found a ready-made solution builder that has such a built-in function. We need to make a similar one only for our site. Tiktok account for testing links is available. If you need I can give a link to this ready-made solution (you can see it on the video).

Рекламная компания google performance max долго не работала и сейчас после запуска выдает странные результаты, нужно проверить все ли настроено, возможно подкоректировать и дать рекомендации

Ми маємо сайт з торгівлі на форекс біржі, нам треба запустити Адвордс на неї. Потрібна наявність досвіду в цьому

Вітаємо, Samiullah K.! Я звернув увагу на ваш профіль і хотів би запропонувати вам свій проект. Ми можемо обговорити деталі в чаті.

...reference. Видео будут предоставляться на постоянной основе. Оплата по инвойсу в конце следующего месяца. Например - с 1 по 31 августа было отредактировано 10 видео. Оплата за все 10 будет в конце сентября. Videos will be provided on a regular basis. The payment will be done at the end of the next month (if you finished 10 videos during August, you'll get paid for all 10 videos on the last week of September). Оплата начинается с базовой ставки за 1 видео и может возрастать в зависимости от качества и скорости работы. The fares start with basic and may increase based on your skills and work speed.

Робимо апгрейд цього проєкту: Проєкт на Ruby on Rails готовий на 70%. Необхідно: - інтегрувати платіжну систему (Liqpay); - доробити бізнес-логіку (додати момент обов'язкової реєстрації, платежу); - виправити дрібні помилки (правильна логіка для логіну/реєстрації користувача, збереження документів, скачування документів та інше). У випадку якісної роботи розглядаємо можливості постійної співпраці та підтримки проєкту.

Настроить тему bigcommerce под наши нужды. Добавить свои методы оплаты и доставки. Інтеграція с 1С, АМО, Бітрікс24 Set up the bigcommerce theme to fit our needs. Аdd customize payment and shipping methods. Integration with 1C, AMO, Bitrix24 Ми вже маємо аккаунт на bigcommerce і придбали тему. Нам потрібна швидка допомога з налаштуванням цієї теми та внесення деяких змін, якщо це можливо. У нас вже є бачення того, як це має виглядати. Крім того, ми шукаємо когось з досвідом підключення методів оплати і доставки, які не доступні на bigcommerce. Для цього потрібні навички кодування та знання платформи bigcommerce. Інтеграції, які нас цікавлять: 1. Методи оплати: - Privat24 - Payoneer - Transferwise - Western Union - payment by card (Mastercard, Visa) 2. Доставка: - Novaposhta - Ukrpo...

Потрібно налаштувати рекламні компанії у Google Ads! По продажу ноутбуків та сервісному центрі! Наш сайт Пропонуйте свої пропозиції!

Потрібно налаштувати рекламні компанії у Google Ads! По продажу ноутбуків та сервісному центрі! Наш сайт Пропонуйте свої пропозиції!

Потрібна допомога в налаштуванні контекстної реклами. Ми - сервісний центр по ремонту та обслуговуванню комп'ютерів, ноутбуків, телефонів, планшетів у м. Львів. Є недавно створений сайт.

Потрібно налаштувати та запустити рекламну кампанію двох груп товарів в інтернет магазині

Фірма займається легалізацією побуту іноземців на території Євросоузу, організовує мовні курси, допомагає студентам вступити до вузів ЄС. Необхідно створити гарний сайт і позиціонувати його в топ-5 чи 10 в Google для отримання великої кількості клієнтів. Розгляну і інші пропозиції щодо пошуку клієнтів.

The project consists of an AI-based booking platform that receives booking orders from various text sources. The text does not have a predefined format. The AI analyzes the text to generate the corresponding booking order in a predefined format, enabling integration with a small ERP software. Input and output data must be defined and calling functions created in C# if required. The AI is desired to be working on a private local server running Microsoft Windows Server.

I'm in need of a specialized web designer to build a portfolio website for me....need of a specialized web designer to build a portfolio website for me. Here's an overview of what I'm looking for: - The website should be compact, with a structure of 1-5 pages. - A significant feature of the website should be a section dedicated to showcasing my previous works. Creativity and uniqueness would be appreciated in its presentation. - The easily accessible contact information is another key element to be included. A freelancer with a wealth of experience in designing portfolio websites would be ideal for this project. An understanding of simple, user-friendly interfaces is important. I'd also like to see previous portfolio websites you've designed. A keen eye for ...

I am in need of an experienced software developer who can create a Windows-based kiosk application to facilitate student registrations, check-ins, and attendance tracking in a learning school. This will be a user-friendly, touchscreen-based solution, with no requirement for integration with existing systems or databases. Key Features: - Student Registration: The application should allow for the quick and easy registration of new students. - Student Check-In: A reliable and efficient check-in system for students. - Attendance Tracking: Real-time attendance monitoring and tracking. Key Requirements: - Proficiency in Windows-based application development. - Experience in creating user-friendly and touchscreen-compatible interfaces. - Prior experience with kiosk applica...

I'm seeking a creative individual who can shape a portfolio for my architecture portifolio , showcasing 5-10 selected projects. The focus would be on mainly 6 projects - Experts in architectural design are preferred, as you'll ' be responsible for picking out stunning visuals and marrying them with concise, descriptive copy. - Specific tasks include selecting images, formatting the portfolio layout, and writing brief descriptions for each project. - A strong understanding of architecture and experience designing visually compelling and professional portfolios is a must. - The ability to communicate the unique vision of each project through your descriptions and your choice of visuals is key. Your aim is to make each project shine and appeal to potentia...

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.

I'm in need of an experienced freelancer who can craft a Wikipedia page for a biography. Key Requirements: - The main topic of the page will be a book, particularly a biography. - The successful candidate should have a solid background ...The main topic of the page will be a book, particularly a biography. - The successful candidate should have a solid background in similar projects, and be able to demonstrate their experience. Ideal Skills: - Proven track record of creating successful Wikipedia pages. - Excellent research skills to gather accurate and relevant information. - A deep understanding of Wikipedia's guidelines and formatting. - Strong written communication skills to compile the information into a coherent and engaging page. Please include past experience ...

I am seeking a skilled Swift iOS developer who can create an innovative, user-friendly application for managing driving routes via GIS .shp files. Key Features: 1. Import GIS .shp files and convert them into driving routes. 2. Incorporate a web portal feature to assign and track drivers. 3. Real-time updates on the progress of each route. The ideal freelancer for this project should have experience with Swift, iOS development, .shp file manipulation, and incorporating real-time updates into an app. The app also needs a mobile version for drivers to access their routes; therefore, experience with mobile app development is also desired. More specifications will be provided upon selection. Looking forward to a fruitful partnership.

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I'm seeking a professional with expertise in Visual Software to adjust my company's quote template. Key responsibilities would include: - Adding permanent text, specifically our company's terms and cond...company's quote template. Key responsibilities would include: - Adding permanent text, specifically our company's terms and conditions, to all of our quotations. Your skill in precision and attention to detail will be key as we need this text to always appear directly below the quote details. Ideal freelancer should have: - Proficient skills in Visual Software - Experience in document formatting - Strong attention to detail Your job will ensure our terms and conditions are always visible and clear, enhancing our business professionalism and clari...

Key Features: - Online Booking: Parents should be able to make, alter, and cancel their bookings with ease.

I require a skilled photo editor who specializes in faces for an intricate job. The task includes: - Replacing a face with another face - I have already selected and provided the replacement. - High attention to detail in the replacement is essential, ensuring that the replaced face maintains distinctive textures, precise skin tone, and features. Ideal candidates will have substantial experience in photo retouching and color correction, ability to handle background removal with finesse, and must demonstrate proficiency in maintaining high levels of detail in their work. Portfolio showing past face replacement edits is highly desirable.

...Messages with Pop-ups • Error • Success Credit Card Tokenization on the Front End • Use API to tokenize credit card information before sending it to the backend Device Responsiveness • Cell phone • Desktop • Notebook • WideScreen Monitors • Tablets Pagination of Cards on the HOME Page and SEARCH RESULTS Page • Pagination Implementation: Use a pagination library like react-paginate . Organization of Cards, according to the Filters Used in the Search Results • Available Filters:  Category  Price  Location  Availability • Ordering:  Relevance  Price (lower to higher/higher to lower)  User reviews XSS Protection • Sanitize all user inputs. • Use libraries like DOMPurify Compatibility with Maj...

I need a diligent freelancer to copy and paste text for me. Key Project Details: - Copy and Paste: The task involves copying text from one source and pasting it into another. - Source of Content: The text will be sourced from various online platforms. - Timeframe: I need this task completed urgently. Ideal Freelancer: - Attention to Detail: It is crucial that the text is copied accurately. - Speed: Given the urgent nature of the project, a quick turnaround is essential. Please provide your experience with similar projects and your availability.

I'm in need of an Appy Pie expert to build an e-commerce website for me. The website will only have less than 50 products, so it's not a large scale project. I have paid Appie Pie full subscription to use their platform Key Requirements: - Build an E-commerce website on Appy Pie platform - Implement payment gateways: PayPal, Stripe, Credit/Debit Cards - Ensure smooth user experience for shopping Ideal Skills: - Proficient in Appy Pie platform Skills - E-commerce website development experience - Strong knowledge of integrating payment gateways - User experience and design sensibility I'm looking for a skilled professional who can bring my vision to life efficiently and effectively. Please provide relevant samples of your previous work and an estimated timeline for...

Collaboration Context: We are looking for a senior freelance SEO consultant to work on an annual SEO project for a well-known small appliance brand in the United States, which is part of an international group. The website is an e-commerce site. This profile will work integrated into the SEO team for AMERICA that the client has formed, along with other management and technical members so that teamwork will be an essential condition. The project is a global project where each region has its strategy, but all must go hand in hand. The consultant will become part of our network of freelancers, with the possibility of participating in other projects for which a profile like theirs is sought. What do we offer? - The possibility of joining a multicultural team and working in the dynami...

I'm in need of a professional who can help overhaul my resume for a career advancement opportunity. The main focus is on improving the content and wording of the document and ensuring a more appealing formatting and layout. This resume will be used to apply for government jo bs. Key tasks include: - Restructuring the content to effectively showcase my skills and experiences - Enhancing the wording to be more impactful and professional - Designing a layout that is visually appealing and easy to navigate, while also adhering to industry standards Ideal candidates should have: - Proven experience in resume writing, particularly in the field of career advancement - Strong grasp of what makes an effective and engaging resume, with the ability to rephrase content for maximum...

Will give u layout to design the packaging.

I'm looking to build a robust web-based color prediction application with additional features crucial to its success. This includes a user registration/login system, real-time data analytics, and payment gateway integration. The app will also require seamless integration with specific game APIs such as live casino, betting, and potentially others. Key Requirements: - Development of a web-based color prediction application - Implementation of user registration/login system - Integration of real-time data analytics - Seamless payment gateway integration - Integration with live casino and betting game APIs - Potential for additional API integrations Ideal Skills: - Web development expertise (React.js, Node.js, etc.) - Strong experience with real-time data analytics - Pro...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document. The job has to be completed in the next 12 hours.

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document.

I'm looking for a developer who is proficient with Google Cloud Platform and PHP to set up my website. Key Requirements: - Google Cloud Platform: You should have experience with GCP, including setting up and configuring services. - PHP 5.6: You will need to work with PHP 5.6 to ensure the website's functionality. - MySQL 5.0.96: Proficiency with MySQL 5.0.96 is essential for database integration. - FTP: You should be able to set up FTP to allow for the uploading of files. - Cloudflare: You will also be responsible for making necessary configuration changes in Cloudflare. Ideal Skills: - Experience with Google Cloud Platform - Proficiency in PHP 5.6 and MySQL 5.0.96 - Knowledge of setting up FTP - Familiarity with Cloudflare configurations - Ability to ensu...

...spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all information This project is straightforward but requires a meticulous approach to ensure al...

I'm seeking a developer to create a comprehensive members' social media software. This software should be responsive and functional across both web and mobile platforms. Key Functionalities: -Instant messaging: Members should be able to privately communicate with one another. -Photo and video sharing: A core function should include the sharing and commenting of multimedia content. -Blogging and forums: Members must have the ability to write posts and create threads for discussions. The platform should optimally support a user base of 1,000 to 5,000 members. Applicants should have a robust background in social media software development and be experienced in implementing the functionalities listed above. An understanding of scalability will be crucial for this project.

I'm looking to create a comprehensive web-based accounting software with essential features that will allow me to manage my finances, track inventory, generate GST reports, and handle billing. This software should also support up to 5 users. Key Features Needed: - Financial Management: The software should offer robust financial management functionalities to help me track and manage my finances effectively. - Inventory Management: A sophisticated inventory management system is required which involves product categorization, stock monitoring, and purchase order tracking. - GST Reporting: The software should have the capability to generate accurate GST reports in compliance with the relevant regulations. - Billing Features: I would require the software to support invoicing, payme...

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 ...

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...