Auto format for specific values in cells

[flgrl0117]

Hello, is it possible to create a formula that will highlight specific values in cells different colors? Example, I have a spreadsheet that has values CANCELLED, COMPLETED, IN PROGRESS, BLOWOUT, in various cells within a column. If the value = CANCELLED, I want that cell to highlight yellow, if the value = COMPLETED, I want that cell to auto highlight green, etc. Is this even possible, and if so, what would the formula be for this?

Thank you in advance for your help.

~Kelly

[elayaz]

Perhaps, conditional formatting?

[FDibbins]

Hi and welcome to the forum

You can do this with Conditional Formatting, as suggested.
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select "format cells that contain"
4. on the "format only cells with" dropdown, select "specific text"
enter the text for 1 rule select the formatting required, and then repeat this for the other words

[flgrl0117]

This is awesome!! Thank you for the welcome and thank you for the help!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

[flgrl0117]

Done and done.