How do you change the colour of the box

Hi Louisa,

Thank you for using the forum to ask a question.

Are you talking about formatting the colour of a cell?
You might this video helpful as it's a topic we'd cover on our Excel Introduction course.

Change the format of a cell
https://support.microsoft.com/en-us/office/change-the-format-of-a-cell-0a45ff85-ee24-4276-94e8-aed6083e8050

If you want it to change colour based on the text/value in the cell this is covered under the conditional formatting section of the Excel Intermediate manual.

Please see a helpful blog article on how to use conditional formatting for a remind of the technique

Use conditional formatting to analyse data in Excel
https://www.stl-training.co.uk/b/use-conditional-formatting-to-analyse-data-in-excel/

If you have a specific question having looked at the manual and blog article please do reply here so we can assist.

Kind regards

Richard