Hello
I have a column of duplicate values Like this :
100
200
-100
50
80
-100
and want a code to change cell fill color based on active cell absolute value.
It means when i select cell with value "100" and run mucro , the fill color of all cells with 100 and -100 values change .
Thanks in advane .![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
I have a column of duplicate values Like this :
100
200
-100
50
80
-100
and want a code to change cell fill color based on active cell absolute value.
It means when i select cell with value "100" and run mucro , the fill color of all cells with 100 and -100 values change .
Thanks in advane .
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)