Conditional formulas: color code text populated cells?
Great! Thank you so much!!! :) ~TKT
"JE McGimpsey" wrote:
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
|