Excel vlookup change cell color työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
EDIT 2 PHOTOS (CHANGES NUMBER/DATES I NEED TO CHANGE X2 SCREEN SHOTS, CHANGING THE DATES, NUMBERS ETC, 10min job
...theme for my upcoming website. Our website domain is - not yet online. The business is going to be called Daily Brewers. We will sell high end boutique coffee equipment. Key Deliverables: - A unique, memorable logo that embodies my brand - A website theme that complements the logo and reflects the minimalist style Things to Consider: - Please note that I have not finalized a color scheme. I'm open to hearing your suggestions on colors that could enhance the minimalist style. - I'm particularly interested in a modern and minimalist aesthetic for both the logo and the website theme. So, your portfolio should reflect your expertise in this area. - Experience with branding is a plus, as I'm looking not only for individual designs, but for a cohesive brand identity....
...for a professional PPT designer to beautify a Networking related deck. Need some info-graphics designed and built as required for some slides. Looking for someone who has experience in designing and building highly Technical yet creative PPT slide decks. Someone who can act quickly and deliver the project ASAP. Prefer someone who can showcase their portfolio of similar work. We will share the color scheme and some guidelines to be followed in-order to work on this project. Would prefer a professional who can stick to the guidelines and be creative accordingly and maintain a very clear prompt communication on the requirements and progress of the project. If the work and the professionalism is something that aligns with us, we will continue to give more similar work in the futu...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
...) - splashscreen while itloads, then on to the main screen - thumbnails of images, divided into themes - when the user clicks an image it’d take them to the coloring screen - tools: brush, paint bucket, eraser - ability for any coloring to be restricted to be “within the lines”, so it only paints within the white fields - option to choose brush size - option to choose eraser size - color picker or color wheel - undo / redo states - save image (to their photos library) - option to save or pick from some predefined palettes??? - option to save current works in progress??? - does not need to support ads, it’ll be a one-time purchase app I’ve attached a sample copy that just sort of outlines the idea, just an AI generated sample cobbled ...
I need a logo designer who excels at creating friendly-style logos for strengthening the online presence of a brand. My ideal logo incorporates the company name and complements our brand identity with its inviting and approach...- Should have experience in creating minimalistic, vintage, and modern logo styles, focusing particularly on 'Friendly' type - Proficiency in creating logos that significantly improve online presence - Ability to include the company name in the logo design creatively Skills and Experience: - Proven experience in logo design, particularly for online brand building - Excellent understanding of color theories, typography, and visual designing - Proven ability to deliver unique and friendly logo designs - Strong portfolio demonstrating a range of st...
...by excess fabric * Adjusting the fit of the jeans for a more streamlined, natural look * Dutifully preserving the overall originality of the jean’s look in the editing process IDEAL SKILLS AND EXPERIENCE: *Proven proficiency in digital image editing, especially related to fashion products *Strong awareness of natural skin and fabric textures to maintain realism *Adept at working with both the color and shape facets of complex images *Exceptional attention to detail and understanding of modern fashion aesthetics The ultimate goal is to create images that put the product in the best possible light, enhancing its attractiveness without losing its authentic feel. I'm keen on collaborating with someone who’s eager to bring out the best in our products, making them ...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...
...elements should be text-based. Colors: The design should use no more than three colors. Logo: Incorporate our signature "H" logo prominently in the design. Local Recognition: The design should convey that Brandon Hamilton is a well-known and trusted local attorney. Back of Shirt: The back of the shirt should include the phrase "Brandon's got my Back!" Background Color: The t-shirt will have a heather gray background or a similar color. Creative Freedom: While we want the design to be clean and professional, we encourage creativity within the constraints provided. Inspiration: We will provide examples of t-shirt designs we like, as well as other advertisements to showcase our colors and themes. Please use these for inspiration but ensure the final d...
I'm seeking a skilled graphic designer to modernize my organization's image. The focus is creating a symbolic logo and other graphics showcasing the essence of a Model United Nations education platform. Ideal skills include: - Experience in rebranding, specifically in the educational or non-profit sectors. - Ability to work with cool-color palette (blues, greens, violets). - Proficiency in designing symbolic graphics, capturing the mission of our organization. Your task is to elevate our brand recognition and help attract new students, through visuals that represent our work in a modern, influential way. We are Tampa Bay Homeschool Model United Nations, committed to supporting debate education; reflect this identity in your designs.
I'm looking for a modern, sleek logo for my luxury watch company. The logo should reflect the brand name: Waters Watch Company. The primary colors are silver and blue. The logo will be used both online and in print, so it's essential that it's versatile and effective in differ...watch company. The logo should reflect the brand name: Waters Watch Company. The primary colors are silver and blue. The logo will be used both online and in print, so it's essential that it's versatile and effective in different contexts. It must include a JPEG file and a vector file at a minimum. Ideal Skills: - Experience in luxury brand design - Proficiency in logo design - Understanding of color psychology - Ability to create versatile and scalable designs - Strong portfolio...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
...wedding seating assignment. The design should be open to interpretation as I'm unsure about the style, but it should certainly incorporate pastel colors. Essential details on the poster should include the guests' names and table assignments, along with the names of the bride and groom. The ideal freelancer for this job would have experience designing wedding stationery and a keen eye for blending color schemes seamlessly....
We require a professional logo that will serve as the identity of our brand to include our business name: Tan Your Way Wellness Spa. Key requirements: - The logo should reflect a professional tone, considering it's for a brand identity. It needs to communicate reliability, credibility and expertise. - Please note that we do not have specific colours in mind for the logo. Feel free to suggest a color scheme that aligns with a professional image. - The design should be versatile and adaptable for use across different mediums, such as print, digital, and social media. Ideal Skills and Experience: - Experience in designing logos for brand identity. - Understanding of colour psychology and its application in creating professional and trustworthy visuals. - Proficiency in creat...
I need to modify the software of the speedometer and DVD touch screen in my Honda Grace 2018 EX. Both are currently in Japanese, and I'd like them to be changed to English. The main tasks for the project include: - Changing the speedometer language from Japanese to English - Modifying the software of the DVD touch screen, also from Japanese to English Since I don't have the necessary tools or software for these modifications, I'm looking for a professional who can provide the expertise and tools required to complete this task. Ideal skills and experience for this job: - Proficient in software modification for car devices - Experience in Honda car systems is a plus - Ability to provide the necessary tools and software for the modification.
...of a seasoned Flutter developer to help me with the setup and customization of a mobile application that is primarily designed for doctors. Key Tasks: - Setup the app for both Android and iOS platforms - Implement a new color scheme to enhance the app's aesthetic - Make necessary layout adjustments to improve user experience - Replace the current logo with a new one Ideal Skills & Experience: - Proficiency in Flutter with a proven track record of building and customizing apps for both Android and iOS - Strong design sense to ensure a seamless integration of the new color scheme - Experience with layout optimization for mobile apps - Previous logo design experience is a plus This project requires someone who can work efficiently and has a keen eye for detail to ...
I'm looking for a skilled graphic designer to create a logo for an insurance company that specializes in commercial business, home, auto, and life insurance. Name of company is Build 2 Suit Insurance Advisors Key Project Details: - Color Scheme: The logo should incorporate shades of blue and orange. - Emotion & Message: The design needs to reflect a sense of professionalism and modernity. Ideal Skill Set: • Proven experience in logo design • Strong understanding of color theory • Ability to convey complex messages through simple designs. Please include similar previous work samples in your proposal.
I require professional assistance to transition the property deed, currently under an individual's name, to a trust. The property in question is a residential one in renton, wahsington state. - Transfer of Deed: Need to transfer residential property deed from an individual's name to a trust. - Deed expertise: Familiarity with property law, especially related to the transfer and change of deeds is crucial. The ideal applicant for this task would have a proven track record in handling such transitions with a deep understanding of the legal implications and process involved. Legal background and previous experience in real estate law are a must.
...botanicals included. See photos - i like the addition of 1 bug or butterfly. - The color scheme should be based on cool tones, specifically blues, greens ,but with pinks. No black background, white is best for that so that the colors pop. These colors should be harmoniously blended to create a soothing and aesthetically pleasing piece. - The art print's primary motif should be a large scale floral design. This design should be striking and suitable for wall art in a home. Ideal Skills and Experience: - Proven experience in creating high-quality, original abstract art prints, particularly with floral and botanical motifs. - Proficiency in digital art and designing for large-scale printing. - A strong sense of color theory, especially with cool tones. - The ability to ...
Seeking an artist to create a female manga character in a style reminiscent of Chrono Crusade's Rosette (for face). See the "Art_Request" attachment for example of what I want to receive for this request. I only need a front, back and side. Intention is to make a 3D model from this 2D art. I will be making the 3D model, just need the 2D manga art. No color. Just black and white inked drawing just like traditional manga. Female character 23 years old Outfit should be the same as shown in attached files Hair should be the same as shown in attached files
I'm in need of an experienced photo editor who is skilled in facial adjustments, specifically in chin reduction. The primary task for this project involves subtle refinement of the chin area while preserving a natural and realistic appearance. Although no other facial adjustments are needed for this particular task, I'd prefer if you have a broader expertise in editing tasks such as retouching, color correction, background removal and photo manipulation. It's very important for the final output to appear natural and realistic. Therefore, a discerning eye for detail and a clear understanding of facial anatomy is a must.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I'm in need of an experienced photo editor who is skilled in facial adjustments, specifically in chin reduction. The primary task for this project involves subtle refinement of the chin area while preserving a natural and realistic appearance. Although no other facial adjustments are needed for this particular task, I'd prefer if you have a broader expertise in editing tasks such as retouching, color correction, background removal and photo manipulation. It's very important for the final output to appear natural and realistic. Therefore, a discerning eye for detail and a clear understanding of facial anatomy is a must.
I'm looking for a skilled designer to help create a logo for my Farm2Fork brand. The design should be in line with my website, which has a clean and modern aesthetic. Our website is Farm2Fork taste the difference Key Requirements: - Logo style: Minimalist - Color Scheme: Open to suggestions - Imagery: Should incorporate farm animals Ideal Skills: - Extensive experience in logo design - A keen eye for minimalist design - Ability to create engaging, modern visual identities - Understanding of how to incorporate thematic elements into a logo.
I'm looking for a talented design...Requirements: - The primary goal is to establish a strong brand identity through the logo. It should be memorable and easily recognisable. - Potentially reference CCTV, ACCESS CONTROL OR INTRUDER ALARMS. - I'm open to suggestions regarding the color scheme. Feel free to propose a palette that you believe suits the modern and minimalist style. Ideal Skills: - Proven experience in logo design, especially in creating logos that emphasize brand identity. - A strong portfolio showcasing modern and minimalist design aesthetics. - Excellent understanding of color psychology in design. - Ability to translate abstract ideas into compelling visual concepts. I welcome creativity and out-of-the-box thinking in this project. Looking forwar...
I have a file that was completed. However the designer as unable to make sure the background would print in navy blue. I am attaching the file but need to make sure the following directives are met for the background. Cyan and Magenta need to be 30% apart Need someone that can send in CMYK format Suggested Color for navy100, 91, 42, 59 The backdrop will be 8'8 in size
I need a designer to help cr...of logo: a representation of hands (see 1 in image file). 2. Middle of logo: a water drop with a leaf inside (similar to 2 in image file) or something similar 3. Top of logo: an element which signifies technology or deep thinking. 4. includes the name “AgroNovare” being creative with the text (for example you see the triangle between the “o” and “a” in 2 (see 4 in the attached). - Color scheme should be block (not gradiated) deep green and navy blue on transparent background. - The font should be modern in navy blue - The logo can be any shape or dimentions. Any logos generated by ChatGPT will be rejected. The final deliverables must be: - A PNG/SVG/TIF file for immediate use. - An EPS file for scal...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I'm in need of a professional, modern and trustworthy logo for my company. The design should incorporate any variation of the colors blue, red, or green. The logo DOES NOT have to include all colors or even be multicolored but these are the preferred colors. Key Requirements: - Colors: Blue, Red, Green - Emotions: Professional, Modern, T...incorporate any variation of the colors blue, red, or green. The logo DOES NOT have to include all colors or even be multicolored but these are the preferred colors. Key Requirements: - Colors: Blue, Red, Green - Emotions: Professional, Modern, Trustworthy - Usage: Primarily for Website, Business cards, Social media profiles Ideal Skills: - Graphic Design - Logo Design - Branding Expertise - Color Theory Understanding - Experience in Cor...
...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...
I'm the owner of a WordPress website and have administrative access. I'm looking for a skilled developer to help me change the admin email without altering the username, password, or other settings. The primary reason for this change is to ensure that the contact information displayed is up-to-date. Key requirements include: - Updating the admin email: The new email address will be provided to the selected freelancer. - Maintaining username and password: It's crucial that these details remain unchanged. - Preserving other settings: The current configurations, including security measures and other account settings, should not be affected. Ideal skills and experience for this job: - Proficiency in WordPress: The ideal candidate should have a strong background ...
I'm in need of an experienced interior designer to help ...visualize my new living room and bedroom in a modern style through 3D rendering. Key Points: - The design should reflect a modern style, with clean lines and minimalism. - The project will specifically involve the living room and bedroom. Color Scheme: - I'm envisioning a mix of brown, off-white, bright colors, and luxurious colors. - The design should be luxurious and well-coordinated. Ideal Skills and Experience: - Proven experience in interior design, particularly with modern styles. - Proficiency in 3D rendering software. - Strong understanding of color theory and how to combine various colors effectively. - Ability to communicate and interpret design preferences effectively. ** please refer to the...
I'm seekin...branding for my personal use. The main inspiration for the logo should be nature, though you've full creative freedom. Key Points: - This is a personal project, requiring a unique and personalized logo and branding that reflects my love for nature. - The design needs to be distinctive and memorable, setting it apart from common logo themes. - There are no specific color preferences, so you can utilize your creativity in the color selection process. Ideal Skills and Experience: - Proven experience in logo and branding design, particularly with nature-inspired concepts. - Strong portfolio showcasing innovative and unique designs. - Ability to translate abstract ideas into visually appealing concepts. - Good communication skills to ensure the final re...
...with a more sophisticated and professional design. Key Requirements: - Incorporate elements of the current 'B' into the new logo. This could be through the font style or overall concept, providing a sense of continuity for existing customers. - The design should reflect the nature of my business - landscaping. Feel free to integrate subtle elements such as plants, leaves, or a nature-inspired color palette. - While I'm open to fresh ideas, maintaining a level of recognizability with the old logo is important. - the business mostly deals with driveways and patios. not so much gardens - the logo needs to be horizontal as will be used on flyers and website banners/footers Skills and Experience: - Proven track record in logo design, especially in the realm of rebrand...
I need a skilled 3D designer to create a small, realistic airsoft grenade design. The STL file should have: - Detachable parts to add an element of realism and functionality - Multiple color patterns to mimic a genuine grenade - Realistic texture that ensures a life-like feel when handled Your proficiency in 3D designing software, understanding of airsoft replicas, and your consideration of usability in design will be beneficial for this project.
I need a logo for my company, The Royal Guardian, that communicates trust and reliability. The primary color I'd like to see in the design is blue, but feel free to use other colors as accents. Key Specifications: - Company Name: The Royal Guardian - Primary Message: Trust and Reliability - Preferred Color: Blue
I have 6 photos that require fine editing. I have a (hopefully) temporary condition called Bell’s Palsy. This unfortunately came up right before graduation and has made my graduation photos something I am not excited to share. I need editing to make my face resemble its former state, of which I will attach a picture. Specifically, I need an expert with: - Proficiency in color correction and retouching. - Skills in facial structure manipulation, particularly in modifying eye shape, mouth shape, and ensuring symmetry on both sides of the face. This is a delicate and artistic task requiring precision in the reshaping of features without compromising the natural feel. Therefore, prior experience with such projects would be ideal. There is potential for additional pictures ne...
I need to design a new version that is better than my reference and has the same style Logo usage guidelines ,Color palette,Typography guidelines,Iconography
I'm looking for a talented graphic designer for creating packaging designs for my technology and gadgets. Key Points: - No existing brand style or color scheme: Since I'm starting from scratch, I need you to come up with a creative and visually appealing design that will resonate with my target audience. - Understanding of Technology and Gadgets: Ideally, the designer should have prior experience in designing packaging for technology-related products. - Attention to Detail: The packaging design should not only be visually appealing but also practical and informative, showcasing the product in the best way possible. - Versatility: I'm open to your creative input, so you should be comfortable with taking the lead on the creative aspect. If you have a strong portfol...
I'm in need of a talented designer to create a custom wine label for a newly wed couple. The label should exude elegance, as it will be used for a special occasion. The label will be placed on an Italian Pinot Grigio. Size 99 x 93 mm Key Requirements: - The label mu...must embody an elegant aesthetic. - It should include a visual representation of the couple (see photos) Ideal Skillset: - Proficiency in graphic design, particularly in creating elegant, custom designs. - Experience in working with wine labels or similar design projects is a plus. - Ability to incorporate provided photos seamlessly into the design. - Understanding and capability to work with the color palette provided. Please provide examples of previous relevant work in your bid. I'm excited to see w...
I'm on the lookout for a versatile individual who can proficiently handle a variety of media-related tasks for my project. Your role will encompass: - Advanced Video Editing: Expect to work with special effects, motion graphics, and advanced color grading for a range of video content. - Photoshop Expertise: You'll be responsible for creating, editing, and refining images for both social media content and marketing materials. The core themes of the videos you'll be working with are travel, fashion, and food. Ideal candidates for this role should have a blend of skills and experience that include: - Proficiency in video editing software. - Strong knowledge of Photoshop and graphic design principles. - Previous experience working with media content in the travel, fa...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
