Frank Bacchus
Member
Hi there:
Hope all is well. I have a Excel Calendar (uploaded), where I would like to use a Conditional Formatting solution to highlight the cells (range of cells) if the content contains a specific word". As an example, I would like to highlight the B25:F25 in Yellow if the content is "Austin". This is pretty straight forward to do but as I change the content across the days in the calendar, I want the day cell changing the the appropriate assigned color for that location. So if I put Austin in the April 1 cell, it should change to Yellow. Any suggestions would be appreciated. Thanks.
frank
Hope all is well. I have a Excel Calendar (uploaded), where I would like to use a Conditional Formatting solution to highlight the cells (range of cells) if the content contains a specific word". As an example, I would like to highlight the B25:F25 in Yellow if the content is "Austin". This is pretty straight forward to do but as I change the content across the days in the calendar, I want the day cell changing the the appropriate assigned color for that location. So if I put Austin in the April 1 cell, it should change to Yellow. Any suggestions would be appreciated. Thanks.
frank