Conditional Formatting works when individually entered into each cell, but not when in a range.

Upvotes: 2