I am looking for a scrip writer to help me with a Google Sheet Script.
My requirement is:-
I have a google sheet with 20 colums and 500 rows. Column A contains client name. column Q contains account manager who looks after this client. If any of the numbers are not align with the client expectation relevent cell will turn its colour to red or purple. (Use conditional formatting )
All I need is a if there is a client with a red or purple cell I need theses to list down on a seperate sheet. This can be used as a dashboard.
Account Manager 1 Account Manager 2
Client A Client i
Client B Client X
I am willing to pay higher rates for the most experienced freelancers