Howdy,
I need a function that will let me use Conditional Formatting to highlight certain rows. I need to highlight alternating groups of rows based on if the row's value for a specific cell stays the same or changes. So, consider the following spreadsheet:
col Row A B C D
1 x 2 x x
2 y 2 y y
3 z 3 z z
4 d 3 d d
5 e 3 e e
6 f 1 f f
7 k 1 k k
Consider only column B here -
Rows 1 and 2 need to be yellow since they have the same value for B. Then, rows 3,4 and 5 need to be white, then rows 6 and 7 again need to be yellow.
Can anyone help?
Thanks!
I need a function that will let me use Conditional Formatting to highlight certain rows. I need to highlight alternating groups of rows based on if the row's value for a specific cell stays the same or changes. So, consider the following spreadsheet:
col Row A B C D
1 x 2 x x
2 y 2 y y
3 z 3 z z
4 d 3 d d
5 e 3 e e
6 f 1 f f
7 k 1 k k
Consider only column B here -
Rows 1 and 2 need to be yellow since they have the same value for B. Then, rows 3,4 and 5 need to be white, then rows 6 and 7 again need to be yellow.
Can anyone help?
Thanks!
