Hi, can someone please help.
I am after a script that for instance, if the activecell is not within range A1:B500 then it will color the cell yellow.
If the activecell is within the range then it will color the cell red.
I do not want to use the worksheet selection change event as I want to be able to run the script in any worksheet at any time, the color of the cell yellow is just an example this is not actually what my script will do but if someone can help with the basics then I will modify it to suite.
Thanks
I am after a script that for instance, if the activecell is not within range A1:B500 then it will color the cell yellow.
If the activecell is within the range then it will color the cell red.
I do not want to use the worksheet selection change event as I want to be able to run the script in any worksheet at any time, the color of the cell yellow is just an example this is not actually what my script will do but if someone can help with the basics then I will modify it to suite.
Thanks