I'm new to this and trying to find a way to change the cell colour of a mastersheet in my schedules document on the basis of an individual schedule in a different sheet containing text (any text) in the corresponding cell.

In this example, if cell C5 from Layla's individual schedule contains text, it will be coloured in because of the conditional formatting:

Layla's schedule

But how do I make it so that having text in this cell also automatically colours in the correspondig cell in the mastersheet (which would also be cell C5 in the example below) without bringing in the text as well?

mastersheet to be automatically coloured in

Thank you!


Your Answer

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