Find Jobs
Hire Freelancers

Conditionally Format Cells in a column based on formula: when less than value in another column of the same row. 270 entries

$30-250 USD

Ukończony
Opublikowano ponad 3 lata temu

$30-250 USD

Płatne przy odbiorze
Please create conditional formatting for 270 cells in a single column. I created conditional formatting rules for the first 3 cells in the 270 cells, and I need a freelancer who will continue the simple pattern by adding one to the formula therewithin the conditional formatting rule, so that each cell in the column has a rule set to it's unique row. Column P is merged with Q, but for all purposes let's call it column P. The user may enter only numerical values in column P and they must appear in dark red font with light red fill only when that value is less than the value of $Q$5*value in column E. For example, in the array... If P454 is 11,000 and E454 is 10,000, no formatting change takes place. If P224 is 54 and E224 is 75, then the conditional formatting must take place. Just data entry!
Identyfikator projektu: 28428587

Informację o projekcie

32 ofert
Zdalny projekt
Aktywny 3 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Hello, You need write only one conditional formula applying for all cell in a range P14:Q27. I can do this for you within a minute. Please drop a PM if you’re interested. Best regards, Hoang
$30 USD w 1 dzień
5,0 (181 opinii)
7,1
7,1
32 freelancerzy składają oferty o średniej wysokości $67 USD dla tej pracy
Awatar Użytkownika
Hi,I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.
$44 USD w 1 dzień
4,9 (695 opinii)
8,4
8,4
Awatar Użytkownika
Hi there, I can conditional format all the cells according to the instructions u have mentioned in the description, in the shortest time. can we talk? :) Thanks Much, RK.
$55 USD w 1 dzień
5,0 (588 opinii)
8,1
8,1
Awatar Użytkownika
Hello, I can perfectly help you in creating a Conditional formatting rule based on a formula in a way you require. I am advance level Excel expert holding years of experience. I will be happy to discuss in detail.
$50 USD w 1 dzień
4,8 (190 opinii)
7,1
7,1
Awatar Użytkownika
✅ Expert on Advanced Excel ✅ Hi there! I’m expert on VBA, Macro, Nested IF, AND, OR, V-LOOKUP, H-LOOKUP, Match, Index, Data Validation, Conditional Formatting, Excel Automation and Advanced Excel related various administration tasks. I understood your project requirements and can do it accurately. Knock me over chat So, we can discuss more about this project and start work. I hope to hear from you soon! Kindest regards, Aquib Javed
$30 USD w 1 dzień
4,9 (103 opinii)
6,7
6,7
Awatar Użytkownika
hello there, i will help you format column cells based on formula, message we discuss in details please
$30 USD w 1 dzień
4,9 (90 opinii)
6,4
6,4
Awatar Użytkownika
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I would do conditional formatting accordingly. I am now full- time freelancer after job experience of more than two decades. It included more than decade as Manager in Public Listed Companies. My vast experience would help to make your project a quality product at this low cost. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
$30 USD w 1 dzień
5,0 (99 opinii)
5,8
5,8
Awatar Użytkownika
Hi there, what Excel do you use? MS or OpenOffice or Google Sheets? I could do this for you. Best, Karoly
$40 USD w 1 dzień
5,0 (14 opinii)
5,2
5,2
Awatar Użytkownika
I will create Conditional Format Cells in a column based on formula: when less than value in another column of the same row. 270 entries
$50 USD w 2 dni
4,8 (52 opinii)
5,7
5,7
Awatar Użytkownika
Hello there, I can creating your format as you want. I am an Excel expert as I have 5+ years of experience in Excel. As I worked at Advice Interactive Group in the USA for directories submissions for about three years using this software in our routine work. I understand your project description. I have reviewed the attached excel sheet and I can do this task for you. Message me now to discuss more details over chat. What I can do for you in Excel: A. Creating different formulas such as (Lookup, Math, Engineering, Statistical...etc.). B. Creating financial reports. C. Creating management reports. D. Data sorting using pivot tables. E. Creating different charts (Column, Line, Pie, Bar, Area, Scatter...etc.). F. Creating project management charts using both (Program Evaluation and Review Technique (PERT) and Critical path Method (CPM)). G. Python programs to read and modify Excel spreadsheet files. H. Creating simple or complex spreadsheets, including adding styles, charts, and so on. You must see my portfolio now before you hire me. https://www.freelancer.com/u/Ibrahim33 Also, I will not finish your work until you are completely satisfied with your project. Your satisfaction is our first priority. Regards Ibrahim Ragab
$40 USD w 1 dzień
4,9 (49 opinii)
5,6
5,6
Awatar Użytkownika
Hello, I’d really like to work with you on this one if possible! I’m Usman . I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant & Excel. I think my skills and experience will help you and your farm. However, If you take a look at my work and feel that I could help you. I am working on another popular online marketplace with 3 years of a permanent position with a real estate agency. You’ll get all the expected stuff like a great professional service and a fast turn around, at a bit less, and I get a bit more exposure. If the above offer sounds like something you would be interested in, I’d love to hear from you. Regards, Muhammad Usman
$60 USD w 7 dni
5,0 (14 opinii)
5,0
5,0
Awatar Użytkownika
Sir, I am experienced and have gone through the description of your project and i am confident to do this better and also on time. Be sure to get quality work and reliable help at lowest price. I would like to discuss complete details with you for better understanding. Hope to msg me soon... Regards Raghib
$33 USD w 1 dzień
4,9 (58 opinii)
4,9
4,9
Awatar Użytkownika
I am a pro in excel with 7 years of experience , I can continue the simple pattern by adding one to the formula there within the conditional formatting rule, so that each cell in the column has a rule set to it's unique row... Please assign me this task & share more details so that I can start working
$50 USD w 1 dzień
5,0 (7 opinii)
4,7
4,7
Awatar Użytkownika
Greetings, I am ready to start right now and finish the 270 cells in the next 12 hours. I am a professional virtual/personal assistant and a data entry specialist for more than 5 years. I have great experience working with Excel and I understand completely how to do formatting. I am very fast (60 words/min) and I have high attention to details and accuracy. I do many reviews to make sure every thing is correct. I could dedicate 8 hours/ day for your job and my time is very flexible to do the work at the needed time. I accept feedback, edits and changes to get the best of the work as providing high quality work is my first priority. I believe communications are the key for successful work and I hope we could communicate through messages to discuss more about the job. Thank you for your time and consideration. With regards, Mohamed Fawzy
$50 USD w 1 dzień
4,6 (26 opinii)
4,3
4,3
Awatar Użytkownika
Hi. I am a technical writer with knowledge and experience in technical research writing. I have gone through your brief, and given a chance to work on your project, I can deliver quality work. Do hire me. Regards
$167 USD w 1 dzień
4,8 (11 opinii)
3,8
3,8
Awatar Użytkownika
Hello there! I am expert in Excel and and am also doing specialization in Excel Skill for Business. I am also expert in Conditional Formating. I have started a new career as a freelancer. I want to do this job for you and build long term relationship. I hope we will contact me before taking a final decision. Thank for reading my response. Best Regards, Muhammad Zafar Qaimkhani
$31 USD w 1 dzień
5,0 (5 opinii)
2,8
2,8
Awatar Użytkownika
Dear client, I have checked reference. High quality & fast delivery speed promise. I'm an expert of Data processing by using Excel Macro ,C# and Python and I can start right now. So, if you choose me for your project, I will do my best. Thanks.
$140 USD w 7 dni
5,0 (2 opinii)
2,5
2,5
Awatar Użytkownika
Hello there, I have read your project description. I can apply the conditional formatting on all the 270 cells. I can start right now...
$50 USD w 1 dzień
4,2 (3 opinii)
1,2
1,2
Awatar Użytkownika
Hi I have key proficiency and fundamental knowledge in DataEntry fields. I will deliver in rapid turnaround time. My first priority will be to provide you Original work according to your requirements. I will deliver you your order at-least a day before your deadline. I would love to work with you and I hope you will love the work I'll do for you. Thank you
$39 USD w 1 dzień
5,0 (1 opinia)
0,9
0,9
Awatar Użytkownika
I am highly interested to take over this project . i promised that i will complete this project correctly and timely .
$140 USD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I have a degree in HR Management. I am very good in Ms Office. I have good typing speed and good knowledge in Excel, which was my day to day work for 2+ years.
$30 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Acworth, United States
5,0
5
Zweryfikowana metoda płatności
Członek od cze 25, 2020

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.