In my Google Sheets in column F, I want to include the word "LATER" based on magenta color (#ff00ff) that is in column B starting from row 227, how should I write this script?
I'll really appreciate any help provided.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
maybe this will help:
=IF(COUNTBACKGROUNDCOLOR("A"&ROW(), "A1", A8), "LATER", )