Conditional Formatting of Columns in Google Sheets excel table
11 USD You need to solve a task in Google Sheets (not Excel).
Namely, the Conditional Formatting task in a specific range with a custom formula.
Table:
https://docs.google.com/spreadsheets/d/1dkeX0kGGXkSAIUgwIxo671l5RqAb_nKXKXKuITcJtT0OY/edit?usp=sharing
Condition:
1) if a cell in column E contains any of these words:
трубопроводів, електропостачання, Знесення, кондиціонування, столярних, облицювання, роботи
2) AND the adjacent cell in column D does not contain the word "Київська"
then highlight the cell in yellow (column E conditional formatting)
For easier understanding of the task, I have recorded a video. Please watch:
https://fex.net/uk/s/pk7srdc
If you know how to do this, place your bid.
P.S. ChatGpt suggested this formula:
=AND(NOT(REGEXMATCH(D1, "Київська")), REGEXMATCH(E1, "трубопроводів|електропостачання|Знесення|кондиціонування|столярних|облицювання|роботи"))
But it doesn't seem to work for some reason..
Current freelance projects in the category Databases & SQL
Dashboard on Dune AnalyticsStyle reference: dune.com/filarm/polymarket-activity Task To create a neat, visually appealing dashboard on Dune for our bot for Polymarket. At this stage, demonstration (synthetic) data is used — it is generated programmatically but looks logical and plausible, in the style… Databases & SQL ∙ 13 hours 54 minutes back ∙ 9 proposals |
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 1 day 8 hours back ∙ 15 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 3 days 7 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 3 days 19 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 7 days 1 hour back ∙ 16 proposals |
Kamenets-Podolskii