I need to compare a number to a string in which i only compare the number to the number in the string. For example I have a "control" number in some column that needs to be compared against the numbers in all of the other subsequent rows in that column
Ctl #
0.17
Rest of col
0.16 J
1.1
0.20 J
1.1 U
1.2 UJ
0.13 etc.
I need to compare the ctl number to every number in the rest of the cols and if the ctl > other values then highlight the box. I know how to do the for loop and the highlighting but can someone tell me how to compare the 2 values? Thanks
Ctl #
0.17
Rest of col
0.16 J
1.1
0.20 J
1.1 U
1.2 UJ
0.13 etc.
I need to compare the ctl number to every number in the rest of the cols and if the ctl > other values then highlight the box. I know how to do the for loop and the highlighting but can someone tell me how to compare the 2 values? Thanks
