Hey all,

I was wondering if this is possible, I have a column of cells with different values and I want to be able to highlight two cells based on their values. So it would be like this in lets say column E:

E1 On
E2 Off
Invalid
E4 On
E5 Off
Processing
Invalid
On
Invalid
E10 On
E11 Off
Running
E13 Off

So what I want to do it highlight the consecutive cells "On and Off". So the cells E1 & E2, E4 & E5, and E10 & E11, would be highlighted. Is this possible?