Find Jobs
Hire Freelancers

I Need Advice About Conditional Formatting

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
I am trying to create a circuit ID form. If you look at the file, I want the color of the number in the "CIRC. NO." column to change according to the selection of "120/208V" or "277/480V" in cell AC6. I need these numbers to go all the way up to 84 in both color sets for all the cells under "CIRC. NO.". I have gotten it to work for one celll only but it will not transfer to any more cells for some reason when I change the range. So I would end up writing the function for each rule in each cell 168 times which adds up to around 20,000 rules on the entire sheet. Is there something I can do to streamline this process? Am I using the wrong formula? Any help is appreciated, thanks.
Project ID: 18930784

About the project

6 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, i looked at this file, and you need only those 2 conditional formatting you already have, but both need to be fixed. Actually changed a little bit so that the whole range takes from them. If you are interested in working with me, please message me and i will help you in matter of minutes. Thanks, Milan
$15 USD in 0 day
5.0 (436 reviews)
6.9
6.9
6 freelancers are bidding on average $21 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.
$30 USD in 1 day
4.9 (275 reviews)
7.2
7.2
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$25 USD in 1 day
4.9 (290 reviews)
6.6
6.6
User Avatar
Hello, I am Luis and I will be glad to assist you with your Excel issue. Please contact me by chat then we could discuss further details! Looking forward to hearing from you soon! Luis Romero
$15 USD in 0 day
5.0 (103 reviews)
5.3
5.3
User Avatar
Hi About me & what I can provide - 5 Yrs. of Experience in EXCEL & VBA FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS Macro coding HIGH ACCURACY start working IMMEDIATELY.
$15 USD in 0 day
4.9 (17 reviews)
3.5
3.5

About the client

Flag of UNITED STATES
Topeka, United States
0.0
0
Payment method verified
Member since Mar 12, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.