Hey guys,

I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials.

I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help!

Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):

https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin

So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case.

I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.

I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice.

Hope some more skilled people out there can help! 🙂

Regards,
Nicky

​Hey guys,I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials. I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help! Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin  So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case. I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice. Hope some more skilled people out there can help! :)Regards,Nicky   Read More

​