
Suoritettu
Julkaistu
Maksettu toimituksen yhteydessä
I need help with conditional formatting in Excel. Requirements: - Format cell A1 based on the value of cell G1, which is calculated using the formula =COUNTA(E3:E13)*0.091. - Use the following color codes based on G1's value: - Red: 0-25% - Dark Orange: 25-50% - Light Orange: 50-70% - Yellow: 70-99% - Green: 100% Ideal Skills: - Proficient in Microsoft Excel - Experience with conditional formatting - Attention to detail
Projektin tunnus (ID): 40343735
14 ehdotukset
Etäprojekti
Aktiivinen 14 päivää sitten
Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
14 freelancerit tarjoavat keskimäärin $20 USD tätä projektia

Hello Sir, I will set up conditional formatting in Excel to automatically color cell A1 based on the calculated percentage in G1 using your specified ranges and formula. The rules will be accurately applied to reflect each color category from red to green as defined.
$30 USD 1 päivässä
8,9
8,9

Hello, I can help with the job. Can do within few hours. I have very good experience in excel data conditional formatting. I can do using only excel or also possible using VBA Regarding my experience you can check in my reviews with 100% feedback I have 17+ year experience of Python, Excel, Excel VBA and Have 100% feedback So, you can trust me result will be as you need Best Regard
$10 USD 1 päivässä
5,9
5,9

Hello, I can set up accurate conditional formatting rules in Excel to dynamically color A1 based on G1’s calculated percentage ranges with precise thresholds. I’ll ensure a clean, reliable setup that works seamlessly with your existing formula and is easy to maintain.
$20 USD 1 päivässä
5,5
5,5

Hello, I can configure the conditional formatting in your workbook so that cell A1 changes color dynamically based on the calculated value in G1 (=COUNTA(E3:E13)*0.091). I’ll set up the rules to reflect the exact ranges you specified: Red for 0–25% Dark Orange for 25–50% Light Orange for 50–70% Yellow for 70–99% Green for 100% With experience in Excel formulas and formatting, I’ll ensure the rules are precise, easy to maintain, and visually clear. I would be glad to discuss your requirements further and show how I can add value—please reach out to me through chat so we can get started. Best Regards, Moustafa
$10 USD 1 päivässä
5,1
5,1

Hi there, I would like to assist you. Kindly advise me for further instructions. Thank you very much. I will be waiting for your message.
$30 USD 5 päivässä
4,8
4,8

I can quickly set up the conditional formatting exactly as required. This is a straightforward task for me, and I can complete it quickly with accurate results. I will also keep the setup clean and easy for you to maintain.
$10 USD 7 päivässä
4,2
4,2

Hello, I can help you set up the conditional formatting in Excel exactly as required. I have experience working with formula-based rules and will ensure that cell A1 updates correctly based on the value in G1 with accurate color coding. I will apply conditional formatting to cell A1 using formula-based rules that reference cell G1, ensuring color changes dynamically based on percentage thresholds I pay close attention to detail and will make sure the logic works perfectly without any errors. I can complete this task quickly and can start immediately. Thank you for your time, and I look forward to working with you. Best regards, [Your Name]
$15 USD 1 päivässä
2,3
2,3

I’ll set up precise conditional formatting for cell A1 based on your G1 formula—ensuring accurate color coding across all percentage ranges with a clean, error-free setup. With strong Excel expertise, I’ll make sure it updates dynamically and works perfectly with your data. Let’s fix this quickly—share your sheet and I’ll implement it right away!
$20 USD 1 päivässä
0,0
0,0

Durban, South Africa
Maksutapa vahvistettu
Liittynyt huhtik. 2, 2026
$10-30 USD
₹12500-37500 INR
$10-30 USD
$15-25 USD/ tunnissa
min ₹5000000 INR
₹600-1500 INR
£250-750 GBP
€30-250 EUR
$10-30 CAD
$250-750 AUD
€12-18 EUR/ tunnissa
$10-30 USD
$250-750 USD
$2-8 AUD/ tunnissa
$30-250 USD
£20-250 GBP
$30-250 CAD
$10-30 USD
₹1500-12500 INR
₹100-400 INR/ tunnissa