Hi,
I have been trying to compare the ranking of a range of numbers with a base line range of numbers and then colour coding them depending on the value returned.
I am not very good at using the range function and would appreciate any help in managing this.
This is what I have so far,
The base line data is in the first column "A" on every other line from row 9 to 47
The data to compare this to will be inputted from column "J" onwards at the same row values
I would like to be able to chose the column to check hence the user input at the beginning.
This is currently throwing up a 'wrong number of arguments or invalid property assignment' compile error.
Many thanks for all your help,
Bookmarks