xlUser
03-17-2011, 11:28 AM
Hi,
I have data in cells A2 to K5000. I want to colour the entire rows based on criteria being met in column A.
As an example, let’s assume the following values in the first few of rows in A2:A9:
7
7
12
12
12
4
11
11
I want to alternative row colours based on groups of cells as indentified by where consecutive rows contain the same values in column A.
So for instance I want to colour the first group of cells white (the 7s - a2:a3), the next set (the 12s) green, the next set white (just one row here - 4), the next set green (11s) etc for all groups in the entire range.
This is to help visually breakout the groups. Note the colour of the cell should not be conditional on the actual value of the cell, but by being in distinct different groups as indentified by immediate cells having the same value and the actual colour is not really important.
Anyone know how best to do this?
Thanks,
XLUser
I have data in cells A2 to K5000. I want to colour the entire rows based on criteria being met in column A.
As an example, let’s assume the following values in the first few of rows in A2:A9:
7
7
12
12
12
4
11
11
I want to alternative row colours based on groups of cells as indentified by where consecutive rows contain the same values in column A.
So for instance I want to colour the first group of cells white (the 7s - a2:a3), the next set (the 12s) green, the next set white (just one row here - 4), the next set green (11s) etc for all groups in the entire range.
This is to help visually breakout the groups. Note the colour of the cell should not be conditional on the actual value of the cell, but by being in distinct different groups as indentified by immediate cells having the same value and the actual colour is not really important.
Anyone know how best to do this?
Thanks,
XLUser