How to colour text or cell with a multiple choice text field?

Here is some help on that topic

https://help.quickbase.com/user-assistance/color_field.html

There is not an equivalent to the Excel Conditional formatting in QuickBase, at present,  so you need to create a new field for this in addition to the real field.