Formulas

Hello Aimee

Thank you for your question and welcome to the forum.

I think you will be able to accomplish this using conditional formatting.

To apply conditional formatting:
1. Select the cells which you want the highlighting/colour to be applied to.
2. Go to Format - Conditional Formatting.
3. Set a condition, e.g. Cell Value is less than 0.
4. Click the Format button to create the formatting that will be applied if values in the selected cells if the criteria is met, e.g. select red colour on the Patterns tab. Click OK, and OK again to apply your condition to the selected cells.

Kind regards
Amanda