Hello all!
How to format cells so that the content will be limited only to two options?
Here I attached my sheet. I want to format the column K so that the content of the cells will be "Open"/"Closed" only (whole words).
Other thing that came up in my mind is, how to format cell using conditional formatting but to cells contain one whole word.
As example in my sheet is to conditionally format the column K but limited to cells with word "Open" and "Close".
Thank you in advance!
Bookmarks