WELCOME TO THE BOARD!
In order to reference ranges found on other worksheets in Conditional Formatting, you need to name your range and reference it that way.
To name a range, highlight the range, then from the Insert drop down menu, select Name, then select Define. Then give your range a name, like "MyRange".
Then, to reference this range, instead of using something like A1:A100, simply use MyRange.