Load xml file table database using vbnet jobs

I'm looking for a competent web developer who is experienced with Odoo website builder to help me create 20 informational websites for various products. The main aim of these websites is to provide detailed information about each product. Key Requirements: - Development of 20 informational websites using Odoo website builder - Each website should be visually appealing and easy to navigate - The sites should be optimized for SEO to ensure they rank well in search engines - Integration of any necessary plugins or modules to enhance functionality - The completion of the project within a month Ideal candidate: - Extensive experience working with Odoo and its website builder - Proven track record of delivering high-quality, professional websites - Strong understanding of SEO best ...

Hey Mate, got a job for you. Please see attached sheet. Need to report on data sheet, data will be updated month to month. Not sure if this can be done with pivot table? but I'm not familiar with dealing with time calculations. Tab 1 Data table 1 + summary by driver: Average Total time (F) by driver (B). Tab 2 Data table 2 + summary by Sub function code: Average Total time by Sub Function (C). Need ability to exclude rows where F is blank or greater than 17 hours.

I'm looking for an experienced developer to create an e-commerce platform using Spring Boot. Key Requirements: - Full-featured user registration and login functionality - Intuitive product listing and search capabilities - Robust shopping cart and secure checkout process - Development of both the frontend and backend The target audience for the platform is retail customers. Therefore, the design and user interface should be consumer-friendly and engaging. Additionally, the project involves managing IoT devices. This requires a strong understanding of IoT protocols and integration within the platform. Ideal skills and experience include: - Proficiency in Java Spring Boot for backend development - Strong understanding of e-commerce website development - Experience with IoT de...

I recorded a podcast episode on my computer through Riverside, but the audio is distorted. I need a skilled audio engineer to help me fix it. Key details include: - The audio was recorded in WAV format. - The primary issue is distorted sounds rather than background noise or volume fluctuations. Ideally, you should have experience with: - Audio editing software. - Correcting distorted audio without losing quality. - Working with WAV files.

...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 to work with various digital file formats. - Attentive to details, particularly regarding security and user privacy. Pleas...

I'm in need of a skilled Nginx expert to help me configure a server for my application. Some key details about the project are as follows: - I'm looking to implement Load Balancing and SSL termination for my TCP traffic. - On the UDP side, I would like to have the server configured for Streaming Media and DNS Resolving. In addition, the Nginx should be set up on a Linux-based operating system. Ideal skills for this project include: - Proficiency in Nginx configuration and management - Strong understanding of TCP and UDP protocols - Experience with Load Balancing, SSL, Streaming Media and DNS - Linux server administration I'm open to suggestions for the best approach in setting up these features, so good communication and problem-solving skills are a...

...maintaining the manga art style. Your role will involve: - Creating detailed, expressive, and dark characters in the traditional manga style - Designing terrifying environments and settings - Setting the mood with your art and paneling - Working closely with me to ensure that the art matches the script It's essential that you bring a passion for horror and a knowledge of the genre to the table. Your work should be both visually engaging and contribute significantly to building the tension and atmosphere of the webtoon. Ideal skills and experience: - Proficient in manga art style - A strong portfolio of previous horror-themed work - Ability to work collaboratively and take direction - Strong understanding of paneling and storytelling - Excellent communication skills Th...

Hi we have small web application on PHP we have face issue to save or publish some data and some table shorting please bid if you can fix this quickly

I'm on the lookout for a well-versed WordPress developer, proficient in WooCommerce and Google's Page...including payment methods. The ideal freelancer for this job should have formidable experience with WordPress and WooCommerce, a proven track record of improving website performance using PageSpeed Insights, and a comprehensive understanding of e-commerce web development. Good afternoon everyone, I have aweb page in my c panel; I have 2 themes that I want to install. to each one independently by wordpress. In addition to this, I want WooComerce to be able to be used and linked to all payment methods, in different currencies. Please take into consideration we have our added products must also be. Installed plugins. high load level by PageSpeed ​​​​Insights

Hi, I am in need of a skilled professional...CRM platforms - Expertise in developing customer service focused CRM systems - Proven track record in integrating issue tracking and resolution functionality - Proficiency in customer database management and optimization The deliverable is a Web-based CRM application that is easy to navigate and meets all the desired functionality aspects. It would be added advantage if you have previously built CRM systems following a similar brief. This job requires an understanding of how customer service CRM platforms function, and I am eager to work with someone who can bring proven knowledge and experience to the table. The platform should also have capabilities to be improved for future adjustments. I am looking forward to some great prop...

...existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to manipulate or recompute in SPSS or any other program! The SPSS tables currently display: Table 1. 4 columns and 13 rows Table 2. 11 columns and 7 rows Table 3. 11 columns and 6 rows Table 4. 6 columns and 2 rows Table 5. 7 columns and 4 rows Table 6. 11 columns and 4 rows Table 7. 7 columns and 7 rows Total: 57 columns and 43 rows, where not all intersects consist o...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantit...Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Ex...

...improve my website, KEEP IN MIND THAT THE IDEA IS TO IMPROVE THE MOBILE WEBSITE (NOT THE DESK) Our primary goal is to optimize the site's core vitals in 5 out of 6 Core Vitals test. Key Requirements: - Page load speed optimization - Mobile responsiveness enhancement - Core Vitals performance improvement The ideal candidate for this project will have: - Prior experience in website optimization - A strong understanding of Core Web Vitals metrics - Proven ability to enhance mobile responsiveness - Experience in page load speed optimization Your role will be to thoroughly analyze the website and provide a detailed optimization plan. You should then implement the necessary changes to meet the core vitals requirements. A successful outcome will not only improve

I'm looking for a talented web developer to transform my Figma file into an interactive, grid layout webpage. This is a great opportunity for someone who is looking for a challenging project which will demonstrate their ability to implement effective, modern design principles. Here are the key deliverables of this project: - Perfectly replicate my Figma design and translate it into a fully interactive webpage. - Implement a grid layout to optimize content display and improve user experience. - Make the webpage fully responsive, providing optimal viewing and interaction experience across all devices. Skillset Requirement: - Strong understanding of HTML & CSS. - Experience in converting Figma designs into webpages. - Strong background in responsive design principles. - Clea...

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, Oracle etc.

I need a professional to add dimensions to specific sections of my AutoCAD drawing. These added measurements will serve to enhance the amount of detail and provide more informative insights for the viewer. I will send the DWG file on the creation of milestone. Key tasks: - Add metric (meters) dimensions to the DWG file - Pay special attention to select objects and areas requiring measurements Ideal skills and experience: - Expertise in AutoCAD software - Deep understanding of technical drawing and dimensioning standards - Precise attention to detail - Engineering or technical drafting experience would be a plus Your task will be integral in enhancing the sense of scale and data detail for anyone viewing this drawing in the future.

I want a python script that will check the balance of my four wallets inj1.... (injective blockchain), cosmos1.... (cosmos blockchain), osmo1.... (osmo blockchain) and juno1.... (juno blockchain) every 5 seconds. And in case the INJ balance increases, ATOM. OSMO or JUNO, then the entire balance will be transferred fully automatically to another wallet inj1...., cosmos1...., osmo1.... and juno1.....

FEATURES /FUNCTIONALITY Web responsive and no app should be required. Site should display correctly on all mobile devices. • Use PH7 Builder, free opensource dating-site software, but only if that makes the project less expensive to develop. I will not be using all available features, but you can see the capabilities and features here: • Implement my custom Algorithm to calculate matches based on selected filters • Require Chat messaging • Modify software to allow user to record audio and send as message or leave as bio • Profile pic can only come from user camera, not gallery or pasting • Require Match alert notifications • User should be able to exclude matches based

I'm seeking a competent web developer to create a personal blog site specifically designed to host video content. You will be responsible for enabling the site to host videos, ensuring optimal...developer to create a personal blog site specifically designed to host video content. You will be responsible for enabling the site to host videos, ensuring optimal playback, and creating an appealing yet user-friendly interface. Ideal skills include: - Proven experience in HTML/CSS - Understanding of video hosting and embedding - Experience in designing user-friendly websites - Knowledge of website load optimization strategies, particularly relating to video content. Looking forward to work with freelancers who are committed to creating a high-quality, functional, and visually appea...

As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.

...Chatgpt , no google Bard/Gemini, or any other AI tool. Cybersecurity CIA Analysis (2019-Present) Need in-depth analysis of CIA triad in recent research? 5 IEEE papers (2019-present) Comparative table with key insights ⚡ Fast, expert research & delivery Order now & unlock cybersecurity knowledge! Tags: cybersecurity, research, CIA, IEEE, analysis, comparison - Identifying potential vulnerabilities in multiple IoT in smart city systems - Analyzing existing cybersecurity measures - Proposing enhanced security solutions The ideal candidate will understand Security Challenges and Privacy Concerns while using IoT in smart cities, their potential vulnerabilities, and possible solutions. Your role would also involve aiding in comparison and assessment of different cy...

...reverted to the payment success screen. Additionally you will add a field into the product category table and to the product add/edit pages in the admin panel for payment options allowed. Certain product categories can be paid with credit card whereas the others cannot. So something like cc_allowed and the answer would be y or n. Upon the options in the checkout if cc not allowed then this option won’t be available to the customer. You will do the above mentioned functionality and pages and popups if need be. There will also need to be a way to test this functionality before it goes live to the public. This project is only for one individual (no agencies) that currently has no work load and can complete this project within 48 hours of starting. All funds will be...

Tasks: We have three different algorithms for matching a resume with jobs on the website. They are coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Descri...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID,...Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Ex...

I'd like to set up an e-commerce website for selling physical products. Key Features: - Load inventory data from my vendor using API. I think Shopify would be the platform to use - Drop ship from a vendor: The website should be able to facilitate drop shipping from a specific vendor of ours. Ideal Skills: - Experience in e-commerce website development, particularly with physical products. - Knowledge of inventory and drop shipping processes. - Understanding of how to integrate third-party vendors into an e-commerce platform.

I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.

I need an expert API developer to create a functional, reliable API for automating table reservations and event bookings on my website, integrating with Tabology. The task involves: - Understanding the existing booking system on the site - Defining specific automation processes for table reservations and event bookings - Integrating these processes with Tabology to enhance efficiency and usability A successful freelancer for this project should demonstrate significant experience with API development and have a deep understanding of booking system operations. Familiarity with Tabology integration will definitely be an added advantage.

...data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run onc...

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I am looking for a professional logo designer who has a keen eye for creating engaging and dynamic logos. You need to be a creative thinker who can bring fresh new ideas to the table as I do not have a specific concept in mind. Key Responsibilities: - Creating an innovative and captivating logo design - Being open to feedback and willing to make adjustments as needed Ideal Skills: - Extensive experience in logo design - Creative thinking and open-mindedness - Strong communication skills to understand design requirements and feedback I can't wait to see what unique ideas you bring!

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

Hey, I'm looking for a virtual assistant who is fast and efficient, to help me be more productive. Specifically you will help me with content creation and translation of a website. In order for me to select the best person, here is my tiny hiring process: - Sign up at (this is the tool I'm using for my website) - Create a new website (the content can be totally random) - At the end of the website, add an FAQ section in "Classical" style and add two questions and their responses: "How much do I charge per hour", "A fun fact about me". Answer the questions with your real personal answers - Publish the website and share it with me when you apply for the project This should take you 5-10m max depending on how quickly you understand how to u...

I need a talented interior designer who has a knack for modern styles to revamp my home. This includes the living room, kitchen and bedroom. Creativity and originality are crucial; I'm looking for someone to bring fresh, innovative ideas to the table. Experience And Skills: - Understanding of modern interior design elements. - Previous work on residential homes. - Ability to turn visions into reality. - A portfolio showcasing previous design work. The aim of this project is to transform these rooms into efficient, aesthetically pleasing spaces. If you understand the subtleties of modern design and can apply them to residential surroundings, then this project is for you.

I will do these screen design in figma they are exactly 8 screens as following: 1- login 2- home with the table of tasks 3- forget password. 4- my profile. 5- search for vehilce 6- vehicle Details. 7- taking images of vehicle (repeatable screen) 8- Milage screen

I am seeking a knowledgeable AWS specialist to provide server support including the maintenance of an Application Load Balancer. The project also uses Git CD/CI, and support on GIt is required as well. Ideal freelancer skills and experience: - Deep knowledge of AWS services, particularly EC2 and RDS - Experience in setting up and managing Application Load Balancer - Familiarity with Git & CD/CI To make a successful application, please include: - Details of past work experience particularly related to AWS EC2, RDS and load balancer configurations. Looking forward to your applications.

I need a tech-savvy freelancer to create a custom thank you p...custom thank you page for my WooCommerce website. The page should have a particular focus on: - Presenting order details effectively. These details must be displayed within a detailed table, allowing for a comprehensive overview of the purchase made. Ideal skills and experience: - Experience in programming and website development. - Familiarity with WooCommerce and creating custom pages. - A knack for clean, efficient code and attention to detail. - Knowledge in creating user-friendly, intuitive layouts and designs. Please note the client has opted not to include any interactive elements within the detailed table on the thank you page. Therefore, ensuring factual accuracy and perfect presentation of order deta...

I'm seeking a skilled Wordpress developer to create a website for my Auto detailing company. Despite skipping on some details, I'm clear about what I need: • A clean, professional and responsive website with three crucial pages - a Home page, a Services page, and an About Us page. (NOTE: All pages must load quickly and be mobile-friendly) Ideal Experience/Skills: • Proven experience with Wordpress website design • Understanding of efficient and engaging UI/UX principles • Ability to work independently as specifics on color scheme or design preferences are absent • A willingness to suggest design concepts due to lack of specified color or design preferences The application should include: • Past work samples showcasing their design skills, e...

...experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filte...

I'm seeking an interior designer with the skills and experience to create a Bohemian-style design for a /laboratory and living room. The ideal candidate will be able to deliver a design that is both aesthetically pleasing and cost-effective. Key Requirements: - Design for a small space - under 500 sq ft - Bohemian style - Earth tones color scheme Ideal...color scheme Ideal Skills and Experience: - Proven experience in small space design - Creative flair for Bohemian design - Ability to work within a budget - Strong understanding of working with earth tones This project will require close collaboration and communication on design choices and adherence to a strict budget. I'm looking for a designer who can bring fresh, innovative ideas to the table while keeping the...

I am looking for a skilled designer to revamp my Adobe XD file for sbd.school. I would be looking to get a sample web page done prior, for you to design the home page at first instance: I like these websites: ^^^ I want something like these... Ideal Skills and Experience: - Proficiency in Adobe XD - Strong eye for modern design - Ability to understand and follow branding guidelines - Experience working on long documents

I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.

I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.

...optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * Develop and maintain ETL (Extract, Transform, Load) processes using standard tools. * Handle data integration tasks, including aggregation, enrichment, and consolidation. Error Handling: * Implement error-handling mechanisms to identify and address data conversion issues. * Monitor and log data conversion errors, creating processes for error resolution. Performance Tuning: * Optimize data conversion and ETL processes for performance and...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

...system to accommodate a referral program. I envision this program to be multi-faceted, with the capability to track referrals, assign rewards and incentives to referrers, and provide benefits to referred customers. The system should also be able to manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in de...

I'm in need of a skilled CAD designer, experienced in CATIA, to create a custom welding table concept design according to the following requirements: - Dimensions: (L)4000mm * (W)1800mm * (H)400mm - Material: Steel Features that I'd like to be included are: - Adjustable height - Built-in clamps - Hydraulic clamping The ideal candidate for this project should have: - Proficiency in CATIA - Prior experience designing welding tables - A good understanding of different welding table structures and features - Knowledge of steel as a material and its implications for table design

I urgently need a detail-oriented professional to type out the exact table of contents of the book I'll share with you. The end product, 2-3 pages, must be delivered in a Word Document format. You need to follow the same table of content format for the source book. It can be two or three pages. Skills and experience for the job: - Proficiency in MS Word - Strong attention to detail - Experience in transcribing text - Ability to handle potential diagrams or illustrations.

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...

Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish