Find Jobs
Hire Freelancers

Google sheet script color change after time passes by hour

$10-30 USD

已完成
已发布大约 4 年前

$10-30 USD

货到付款
I would need this created for Google Sheets and can share a link to do it on with my other triggers. I would also need the current code i have enhanced for multiple of the same. The end result i am looking for is: If D3 has a date in it (already populates automatically based on C3 being complete) then F3 will change color from green if it is 4 hours passed the D3 date and time, Yellow if it is within 8 hours passed, Orange if it is within 16 hours passed and red if its more than 24 hours passed. If this field contains data (complete is only option) change back to green. This will need to be built in google sheets scripts so it is entirely on this sheet.
项目 ID: 23839186

关于此项目

3提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hello, I’m a Google Sheets expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD 在1天之内
5.0 (106条评论)
6.5
6.5
3威客以平均价$30 USD来参与此工作竞价
用户头像
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$30 USD 在1天之内
4.9 (21条评论)
4.4
4.4
用户头像
Dear Sir, I am a java developer with 5+ years of experience and I have read your requirement. I believe I can do your work with great efficiency. Looking forwarding to hearing from you soon to discuss more about the project. Best Regards, Mithun Kumer Ghose
$30 USD 在7天之内
0.0 (1条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Orlando, United States
5.0
17
付款方式已验证
会员自7月 5, 2013起

客户认证

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