Henk_2596310
New Member
Hi,
I like to highlight rows based on values found in for instance column B. The data is already sorted on column B
Clarification:
Column B has for instance the following values:
A
A
B
B
C
C
C
C
D
.
.
I like to have the rows containing A with a certain background color. The value B can be no color of a different color, C has the same color as A and D gets the same color as B..... etc....
So basically with a value change, a different color need to be used.
As a result, it will highlight the rows which has the value found in column B in common.
Tried some conditional formating without succes. Mayby VBA?
Thank,
Henk
I like to highlight rows based on values found in for instance column B. The data is already sorted on column B
Clarification:
Column B has for instance the following values:
A
A
B
B
C
C
C
C
D
.
.
I like to have the rows containing A with a certain background color. The value B can be no color of a different color, C has the same color as A and D gets the same color as B..... etc....
So basically with a value change, a different color need to be used.
As a result, it will highlight the rows which has the value found in column B in common.
Tried some conditional formating without succes. Mayby VBA?
Thank,
Henk