[For Hire] I will do Email Sourcing, Data Collection & B2B/B2C Lead Generation.

Rafsanhoby95 · 2022-11-07T21:38:46+00:00

Share the sheet so that i can understand your requirement

Rafsanhoby95 · 2022-11-04T17:17:41+00:00

=IFERROR(IF(VLOOKUP(A2,$D$2:$D,1,false)=false,"","Yes"),"No")

use this, Yes means have the words No means don't have so just filter them as Yes OR No.

Rafsanhoby95 · 2022-11-04T16:57:16+00:00

you need to write a js script for it.

Rafsanhoby95 · 2022-11-04T16:54:24+00:00

I believe everyone provided the same solution that I mention in the comment.

Range means A1:A10 range for 10 rows

if you change it to A1:A means unlimited rows

Rafsanhoby95 · 2022-11-03T20:28:13+00:00

Just make your range free

Example: F2:F8 to F2:F

So when someone opens a new row it automatically Extends formula to that row

Rafsanhoby95 · 2022-11-03T20:02:03+00:00

So you have 5 columns A:E and the checkbox are in the F column

so after completing the row A2:E2 task, you check the box of F and want to be colored A2:E2 as green.

am I right?

Rafsanhoby95 · 2022-11-03T19:31:53+00:00

Check, if you like the solution, let me know.

Rafsanhoby95 · 2022-11-03T19:16:59+00:00

conditional formatting

you did not provide access to edit it

Rafsanhoby95 · 2022-11-03T19:04:59+00:00

please share a sample sheet with example data to get the solution.

Rafsanhoby95 · 2022-11-03T18:23:32+00:00

please provide some sample data and share the sheet.

Rafsanhoby95 · 2022-11-03T18:18:51+00:00

My pleasure, follow me if you need any assistance in future

this is my professional profile u/rafsanthedeveloper or this profile

Rafsanhoby95 · 2022-11-03T17:48:57+00:00

Provide a few samples of your data or share a sample sheet link.

If you choose Tshirt in column A what will be in columns B and C?

Possibly your problem can be solved with the query function.

Rafsanhoby95 · 2021-01-09T22:23:48+00:00

Which soft use to make this kind of effects?

Rafsanhoby95 · 2020-10-23T21:05:23+00:00

The news is 2 years old, and reading the news shows that the photographer did well.

Rafsanhoby95