Hello,
I'm hoping someone can help me figure out a formula. I am trying to conditionally format when the value of "1" shows up consecutively twice with one color and conditionally format it if it shows up 3 consecutive times with a different color.
Here's my example:
C4 = 1
C5 = 1
C6 = 0
C7 = 1
C8 = 1
C9 = 1
So, I would want C4 and C5 to be highlighted in yellow, and I would want C7, C8, and C9 to be highlighted in red.
I did try this:
=AND($C4<>"",$C4<>0,OR($C4=$C3,$C4=$C5))
This helps to highlight all consecutive values of "1", but it won't change the color to red when there's 3 consecutive values of "1". They just stay yellow.
Any help is greatly appreciated!
I'm hoping someone can help me figure out a formula. I am trying to conditionally format when the value of "1" shows up consecutively twice with one color and conditionally format it if it shows up 3 consecutive times with a different color.
Here's my example:
C4 = 1
C5 = 1
C6 = 0
C7 = 1
C8 = 1
C9 = 1
So, I would want C4 and C5 to be highlighted in yellow, and I would want C7, C8, and C9 to be highlighted in red.
I did try this:
=AND($C4<>"",$C4<>0,OR($C4=$C3,$C4=$C5))
This helps to highlight all consecutive values of "1", but it won't change the color to red when there's 3 consecutive values of "1". They just stay yellow.
Any help is greatly appreciated!