If "format" formula help needed

[escott403]

I am looking for help writing a formula to distigush between varied text formats.
I want to play out like: IF(B1 = "STRUCKTHROUGH", 1, if (b1 = "RED", 2,3))
[TABLE="width: 96"]
<TBODY>[TR]
[TD="class: xl64, width: 64, bgcolor: transparent"]YES
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]<S>MECH</S>
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]YES
[/TD]
[TD="class: xl66, bgcolor: transparent"]MECH
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]NO
[/TD]
[TD="class: xl67, bgcolor: transparent"]MECH
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[nuked]

You'd need a customer formula to do this.

 

[mikerickson]

You might use GET.CELL http://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

But there are problems with using color and formatting as data.
The first is that if the color is the result of Conditional Formatting, it doesn't read as the conditiional color.
The next is that changing the color or formatting of a cell doesn't trigger a re-calculation, you have to act as if your calculation is set to manual.
The main problem is the user has to remember what the difference between Cat and Cat, it's not intuitive and will be forgotten by the user.