Conditional Color Formatting

[Cozmo35]

Is it possible to make a cell turn a specfic color based the text that is in it?

 

[ajgillert]

How many different colours are you wanting?
Is the 'text' from a predefined or known list of possible values?

 

[Cozmo35]

I am just now building the list. It is an "open issues" list. I have a column that I will type in "Open" or Closed". I would like the Open issues to be yellow in that cell or the "Closed" issued to be red in that cell.

 

[The Todal]

In Conditional Formatting, set Condition 1 to: Cell Value, equal to, ="open". Set the format to yellow fill Pattern. Same for Condition 2 except ="closed" and red fill pattern

 

[Cozmo35]

That was the ticket! Thanks!!!