Hello,
I am creating a calendar to show the schedules of certain devices. What I am looking to do is have the date cell on the calendar change to yellow if the data cell is different than the data in the day before AND not highlight if the day before is empty AND not highlight if the day before contains "5:00". In the attached picture, February 8th and 10th are highlighted as appropriate. February 11th should NOT be highlighted because it is technically the same schedule as the 10th. The 05:00 on the 10th simply says what time it should change. Below is what I have thus far. The calendar goes from columns D to J. This particular formula below is performing conditional formatting on cell E11 (February 8th).
=AND(E$12<>D$12, D$12<>"")
Since I want to apply this to all dates, I have left the row absolute and the column variable. I had to do a special format for Sunday since it looks at the week above. I just need the last piece to my puzzle. "SEARCH" has not worked.
I think the main issue is that I just want to search if the cell contains "5:00". D$12<>"5:00" does not work either.
=AND(E$12<>D$12, D$12<>"", ??????????)
I had to post a picture because the VBA and equations won't allow me to copy/paste a readable calendar that doesn't contain sensitive data.
Bookmarks