I am trying to set up a conditional formatting rule that will highlight blocks of rows where a cell value is different from another in a group of similar items.
So for example column A has a course number. Each course has a number of events, all given the same number.
In column B is the status. Some of those courses will show as "Evaluated" and some as "Not Evaluated". I want to be able to highlight the courses that have a mix of "Evaluated and Not Evaluated. The courses where all events are Evaluated or all events are Not Evaluated should not be highlighted.
An example of the resulting highlighting I'd like to achieve is attached
Grateful for any quick help here for an urgent job.