Roi calculator excel templatepekerjaan

Bonjour, je suis archéologue. J'ai du texte, des photos, des images, un document Excel a insérer dans un seul rapport paginé. Il faut faire la mise en page et transformer en PDF.

I'm looking for an Excel expert to create a costing sheet for a product. Key details for the job include: - It's mainly a costing sheet that will help me calculate the final price of my product based on material costs. Ideal Skills and Experience: - Proficiency in Excel - Solid understanding of financial calculations - Previous experience in creating costing sheets for products Looking forward to receiving your bids.

I require someone adept in research and analysis for a project in the General Merchandise sector. My project is specifically focused on product research and purchasing to maximise ROI. The ideal candidate would demonstrate: - Strong methodical skills - Understanding of procurement process - Some Expertise in product research Considerable understanding of the General Merchandise market will be a huge advantage. Your role will involve selecting product to sell within a defined budget. Your key kpi is maximising ROI which you would ultimately participate in on a profit share basis. Your Trust autonomy and integrity is an absolute requirement.

...foundation is solid, there's significant room for enhancement to create a seamless learning experience. We're seeking a skilled freelancer to customize and optimize our platform to leverage its full potential and provide an enriching learning environment for students, teachers, and administrators alike. Project Objectives: 1. Visual and Functional Customization: - Customize the platform's template for enhanced visual appeal and intuitive navigation. - Ensure seamless usability for administrators, teachers, and students. 2. Online Testing Integration: - Implement online testing functionalities to accurately assess learners' current English proficiency levels. 3. Course and Test Samples: - Integrate sample English learning courses and tests to fa...

I require a detailed, easy-to-use Excel invoice template. The main features needed include: - Line items for products or services delivered: It's crucial that you add functionality for categorizing and detailing all the products or services delivered within the invoice. - Contact Information of both parties: The invoice must have dedicated sections to clearly present contact information of both the issuing and receiving party. - 1 page invoice in A4 size (fixed) with calculations based on user input amount. It's beneficial if you have profound knowledge of Excel and understand accounting principles to design the template in a highly organized and straightforward manner for ease of accounting tasks. Prior experience with invoice template desi...

...would be able to purchase the theme and send it to you! Important: * Website should be done on an external server or similar so that our website will not be disrupted and later uploaded * Not all pages are required. Only the ones in the main menu but not the news (blogs) ones. Estimated 15 pages all together. * Imortorant having the same or other price calculator on the front page. Old website:

I'm looking to engage a freelancer skilled in data entry and Microsoft Excel to help type significant amounts of text data into an Excel sheet. Your responsibility will include: - Typing text data into an Excel sheet in an accurate and efficient manner. - Maintaining a consistent style and format throughout the entirety of the data entry. - Reviewing and proofreading your work to ensure absolute accuracy. You should display proficiency in Excel, attention to detail, and commitment to maintaining a consistent, professional style across all data. Please submit your bids along with an estimate of timeframe. Though the project completion timeframe was not specified, a timely delivery will still be appreciated.

...need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel repo...

...I'll be honest, my budget's tighter than a drum – okay, it's almost non-existent right now. But I believe in the power of good karma, and I'm hopeful that we can work something out that benefits us both down the road. I get it, it's a lot to ask. But if you could help me get 'hiperfect' off the ground, I’d be over the moon. And any advice or pointers would be a lifesaver! THIS IS THE WEBSITE TEMPLATE, THAT NEEDS TO BE CUSTOMIZED: - Develop a logo and branding consistent with the given color palette (#3430FE, #52F124, #6C6D6E, #0F6DF2, #82F225). - Create a sleek and modern web design incorporating these brand elements. Working with AI is a huge advantage. Ideal Candidate: - Hands-on experience with logo design and web desig...

File will be provided with the output as discussed

I'm looking to revamp the Open-Realty Open source templated system significantly. This involves making the first page visited by a user within a session to be their home page. Key areas calling for...a user within a session to be their home page. Key areas calling for improvement are: - Navigation: I want it simplified for ease of access and better user experience. - Referrer System: I'm also keen on integrating a rotating referrer system that will list out three referrers in a specific order. Ideal candidates for this task should have strong experience in website redesign, open-source template modifications and experience with referrer systems. Expertise in UI/UX and understanding of user navigation techniques are crucial. Understanding the workings of Open-Realty sys...

Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The o...

I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.

I'm looking for a skilled web developer who can put together a modern, sleek website for my payday loan business. The project entails creating a website with the following features: - Loan Application Form: A form that's intuitive and uncomplicated, facilitating loan requests from our target audience. - Loan Calculator: Integration of a user-friendly loan calculator that helps visitors understand the costs associated with their loan. - Customer Testimonials: A section where individuals with poor credit, small business owners, and college students can share their experiences with the services we offer. The target audience for the website will be individuals with poor credit, small business owners, and college students. Therefore, it's essential that the design...

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred

I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and d...

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

...translate my brand vision into a website design. I am looking for a website that stands out from competitors and can attract and retain visitors. If you are confident in your abilities to deliver on these points, I would love to see some of your past work and discuss further details. I have started with a simple design that causes some trouble. See: The template has issue on Android 13 as it will not display properly. Ios and Android 14 worked well. So this needs to be fixed. Besides that: please make the centered menu NOT to break to two lines. As soon as the page is narrow enough for it to line break, then use hamburger menu. Then the HEader Section with the menu i want to work as follow: Overlay on the Video with light gray until i start scrolling

I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current demo code lacks a user-friendly interface. ...

I am in need of a highly professional freelancer experienced in designing powerful and captivating PowerPoint templates. Specifically, I'm aiming for a corporate style aesthetic. Key aspects of the project to keep in mind: - Incorporation of infographic elements and text blocks within the template - Effective utilization of a blue and white color scheme - Ability to adhere and translate big concepts and complex information into a readable, enjoyable format. Ideal skills for this project include proficiency with relevant design software and an experienced eye for creating engaging, corporate visuals. Familiarity with constructing infographics is also a plus. It is important to note that the final product must be clean, functional, and businesslike, fully embracing a corporate ...

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.

...digital marketer to set up and manage a Google Ads campaign aimed at generating leads from business professionals. Key requirements include: - Experience with Google Ads, specifically the Search Network - Proven track record in lead generation from similar target audience - Ability to craft compelling ad copy that resonates with business professionals - Structuring of the campaigns to reach maximum ROI Your work will primarily focus on: - Keyword research and selection to reach our target audience - Create effective ad copy and A/B testing - Regularly monitoring and optimizing the campaign for better results - Providing detailed reports outlining performance and your suggested changes The ideal freelancer will have a deep understanding of lead generation on Google Search, exc...

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

...should reflect the innovation and efficiency of our solutions. The website must be visually striking, high-performing, and user-friendly. Responsibilities: Design and develop a responsive, optimized website accessible on all devices. Integrate a section for our ticket management software, highlighting its advantages such as process optimization and artificial intelligence. Implement an online calculator to estimate costs based on the Chilean UF per employee. Set up efficient communication channels (live chat, contact form, etc.). Requirements: Proven experience in both frontend and backend web development. Proficiency in any programming language. Experience with backend systems integration and APIs. Ability to work independently and as part of a team. Excellent communication s...

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

I'm looking for a skilled professional who can set up and optimize Google Merchant Shopping Ads for my e-commerce website, Maxko.nl. I'm aiming to enhance my sales through this platform. Key Responsibilities: - Setting up Google Merchant Shopping Ads for - Conducting research on competitive keywords - Optimizing these ads to maximize ROI - Regularly monitoring and tweaking the campaigns for finer performance - Implementing conversion tracking to assess the effectiveness of the ads The ideal candidate should have: - A proven track record of setting up and managing Google Merchant Shopping Ads - Extensive experience in e-commerce and online marketing - Familiarity with 's e-commerce platform - Strong analytical and problem-solving skills - Demonstrable evidence of i...

...my sales funnel. The graphics include various psds that need text, colors, and some background images changed. Your goal is to take the photoshop templates and customize them for my business. The psd files are organized and easy to edit. Key Points: - Customization in Photoshop templates - Required changes: Text, Colors, Images Ideal candidates should: - Have prior experience in Photoshop template customization - Be creative and have a good sense of design - Be able to effectively communicate through email....

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to colla...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

Bonjour! Je cherche à lancer et personnaliser mon modèle Houzez Wordpress. Voici ce dont j'ai besoin : - Personnalisation : je souhaite obtenir un look unique, nous aurons donc besoin d'une personnalisation de la palette de couleurs et d'une intégration du logo et de la marque pour aligner le site sur l'identité de ma marque. - Restructuration du contenu : Dans le cadre du lancement, la structure du site doit être retravaillée. - Configuration : les tâches clés incluent l'installation et la configuration du modèle Houzez. Nous installerons et configurerons également des plugins critiques, notamment un formulaire de contact, un plugin SEO et un plugin de partage sur les réseaux sociaux. - Co...

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I'm seeking a Google Ads Expert, specialising in PPC campaigns to generate high-quality leads. My main focus is on targeting UK customers. Your responsibilities: - Setup, manage, and optimise our Google Ads. - Develop strategies to increase high-quality leads and ROI. Ideal Freelancer: - Proven experience in similar projects. - Understand UK market. - Certified Google Ads Professional. - Strong understanding of lead generation strategies. This role isn't just about getting more site traffic; it's about gaining high-quality leads. Your experience and skills matter as much as your strategy. Note: This is long term project, if project will success.

I'm looking for a talented designer who specializes in creating innovative and unique templates, specifically catering to the design industry. Key Requirements are: • Photoshop file format • Implement a 'creative and unique' layout style Ideal freelancers will have a keen eye for aesthetics, experience in graphic design and a deep understanding of what appeals within the design industry. They should also be proficient in Photoshop. Efficiency in work and attention to detail are highly appreciated.

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

In need of a designer who's adept at creating PDF templates using Ninja Forms wordpress. The specifics of this project are not heavily directed, thus I'll need someone comfortable with creative initiative and able to work without much guidance....thus I'll need someone comfortable with creative initiative and able to work without much guidance. Essential elements as Header, Footer, Logo, and Text fields should be figured into the design, however, the exact contents of these sections have not been strictly predetermined. Any design style is acceptable as long as it is professional and functional. Ideal candidates should be experienced in template design and Ninja Forms. Please use your discretion when filling in sections like the header with typical information like co...

I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...