I'm looking to Conditionally Format a cell using a formula for another cell if it does not contain certain letters.
Example:
I need to conditionally format Cell B1 to be a certain color if Cell A1 does not contain "T","TC","M","MC","B", or "BC".
So when I type in anything other than those values, I format B1.
I also currently have another condition running in B1 in reference to A1 so this would have to format if the previous condition is not met.
Any Ideas?
Example:
I need to conditionally format Cell B1 to be a certain color if Cell A1 does not contain "T","TC","M","MC","B", or "BC".
So when I type in anything other than those values, I format B1.
I also currently have another condition running in B1 in reference to A1 so this would have to format if the previous condition is not met.
Any Ideas?