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 corresp...
SergeiBaklan
Jun 16, 2017Diamond Contributor
Hi Jennifer,
Most probaly you have to use relative references instaed of absolute ones in your Conditional formatting rule