Highligh Rule

Hi Freya

Thank you for using our forum

It sounds like you're using a conditional formatting that identifies keywords and changes the colour based on the result.

To activate this you can:
Select the range of cells that the rule will be applied to
Go to the Home Ribbon and select Conditional Formatting > Highlight Cell Rules > Text That Contains
Type in the keyword and select the colour you wish to apply
Click on OK

To manage/edit this rule
Go to the Home Ribbon and select Conditional Formatting > Manage Rules
Select This Worksheet from the drop down menu above
Select the applicable rule and click on Edit
Make any changes required
Click on OK

We cover this subject in detail on the Excel Introduction course. You can download the manual from here:
https://www.stl-training.co.uk/microsoft/excel-introduction-courses.php #free-manual

Or find more information here:
https://www.stl-training.co.uk/b/excel-2013-conditional-formatting-through-quick-analysis/
https://www.stl-training.co.uk/b/use-conditional-formatting-to-analyse-data-in-excel/
https://www.stl-training.co.uk/article-2041-unconditional-excellence-conditional-formatting-in-excel.html

I hope this helps

Kind regards
Wendy Canelas
Microsoft Office Trainer