Column B contains a category name
Is there a way to write a formula for conditional formatting that looks at the contents of cell B(row whatever) and if it is equal to the cell above it, then color band it the same, if not alternate.
This would be the result:
Row Format….Column B
Green band…..Category 1
Green band…..Category 1
Green band…..Category 1
White band…..Category 2
White band…..Category 2
Green band…..Category 3
Green band…..Category 3
Green band…..Category 3
Green band…..Category 3
Green band…..Category 3
White band…..Category 4
Green band…..Category 5
Green band…..Category 5
Bookmarks