Forum Discussion
Jennifer Volkmann
Jun 16, 2017Copper Contributor
How do i highlight a particular cell based on the highlight condition of another cell?
Hello Excel world. I need some help. I have created a highlight rule when one cell value is greater than 0 it highlights the cell. Now here is where i get stuck. I would like to highlight the corresponding 3 text and numberical cells that are related to that value. Can someone please help me?
Hi Jennifer,
Most probaly you have to use relative references instaed of absolute ones in your Conditional formatting rule