Hello,

I want some cells to highlight when for example cell A1 is "test1".
I tried to use conditional formatting but it only highlights that particular cell and nog a variety of other cells.
I'm not a very experienced excel user but i think it is a simple VBA code to do this.

I hope somebody can help me here.
Tx