Forum Discussion
Excel conditional formatting by color
if a cell in column B is green i need to change color of all duplicate values in that column to green.
1 Reply
If you want to use conditional formatting, you'd have to formulate a data-based rule to color cells, not a color-based rule.
An alternative would be a macro that loops through the cells in column B. If you encounter a green cell, loop through the cells below to color duplicates. That would be rather time-consuming, and you'd have to run the macro each time you manually color a cell green.
