You can also wrap all cells within the selected range in a Custom Formula you type in yourself. This requires more knowledge and the ability to correctly construct formulas without validation.

It is a great tool in instances where you need an entire range to depend on some condition you didn’t initially include. It can also be useful when presenting in another currency at a subsequent date, and in many other scenarios. The only limit to this feature is your ability to type in correct formulas.