One way:

Assuming that cell A1 is selected:

CF1: =OR(A1="R", A1="render")
Format1: <patterns/<color

In article ,
TKT wrote:

Hi There,

I would like to set up a formula that recognizes the text (i.e. render or
"R") I have noted in a cell and assign a color to it...whichever color I have
designated.

Is this possible or am I asking too much of MS Excel? Please advise....any
feedback would greatly be appreciated!

~TKT