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?
1 Reply
- SergeiBaklanDiamond Contributor
Hi Jennifer,
Most probaly you have to use relative references instaed of absolute ones in your Conditional formatting rule