to change how cells appear, you use conditional formatting. then, to highlight cells with a value of at least $100, you choose to format cells if they have a value greater than or equal to 100.