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 .
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 .
