I am trying to work out a formula or macro to automate a task that is laborious.

I have to compare two sets of data and if they match I change the colour of a cell to show the task has been completed by a crew member.

As the crew size increases this is causing the task to become more time consuming.

The task is required to done twice a week (Monday & Thursday) by crew members.

We receive data from an external company and then if the task is done, I update our spreadsheet showing this on the crew members row and corresponding cell for that date.

I presume I will need to do an IF statement to show if the statement is true change the colour of the cell.

Hope that makes sense?

Thanks in advance!


1 Answer 1


Use a conditional formatting custom formula rule with match().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.