You should end up with a Conditional Formatting formula akin to:

=AND($A1<"",OR($A1<100,$A1500))