Find Jobs
Hire Freelancers

I Need Advice About Conditional Formatting

$10-30 USD

已完成
已发布大约 5 年前

$10-30 USD

货到付款
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.
项目 ID: 18930784

关于此项目

6提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在0天之内
5.0 (436条评论)
6.9
6.9
6威客以平均价$21 USD来参与此工作竞价
用户头像
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 在1天之内
4.9 (275条评论)
7.2
7.2
用户头像
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 在1天之内
4.9 (290条评论)
6.6
6.6
用户头像
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 在0天之内
5.0 (103条评论)
5.3
5.3
用户头像
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 在0天之内
4.9 (17条评论)
3.5
3.5

关于客户

UNITED STATES的国旗
Topeka, United States
0.0
0
付款方式已验证
会员自3月 12, 2019起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。