Hi,

Do: Format>Conditional Formatting.

Then do:

Cell Value : Is Less Than : 100

Then just pick what formatting you want.

SamuelT