Hello everybody,
I am using Excel to make a new planning tool for work, and am having some issues with conditional formatting.
For each employee and each day, the first row is for the working hours, the second one is the place, and the third one is the task (picture 1). I would like that all cells change colors depending on the place. For example, Place 1 would have the color green, Place2 would have the color orange etc... (picture 2)
pic1
Capture d’écran 2022-04-13 à 22.05.01.png
pic2
Capture d’écran 2022-04-13 à 22.05.20.png
I would normally know how to do basic conditional formatting but the fact that the referenced cell is merged makes it confusing. Is there a way of doing that without VBA ?
Thanks!
Nitneroc
Bookmarks