I have a conditional formatting set that if the value of a cell in H is <30 the row is red.
I would like to make it that if a cell in A is red, than all duplicate values of that red cell in A and its row are also red. What would be the formula to do this if there is one?
I would like to make it that if a cell in A is red, than all duplicate values of that red cell in A and its row are also red. What would be the formula to do this if there is one?