How to create macro/vba to highlight or conditional formating to a group of cells.

Ok it worked on the active sheet. but that wud mean that no one else could use it..correct.... how do i share it and use it on other worksheets..with out having to copy and paste it into vba of each worksheet...