Forum Discussion

Jennifer Volkmann's avatar
Jennifer Volkmann
Copper Contributor
Jun 16, 2017

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

Resources