Hi everyone! I hope you are all well.
I'm creating a calendar template based on some tutorials found on the internet.
However, I'm having trouble creating a conditional formatting rule to apply to appointments on a certain day and at a certain time.
The image below shows the model I was able to create. Already able to apply conditional formatting for weekends and holidays where the entire column is painted red and orange respectively.
Capturar.PNG
Now I need to create a conditional formatting rule to paint in green only the cells that represent an appointment for a certain time and a certain day. I want to paint just the cell and not the entire column
1.PNG
However, I still haven't been able to solve this case. can anybody help me?
Attached is the template I created so far.
Thank you very much in advance
Bookmarks