Conditional formulas: color code text populated cells?

[TKT]

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

[Chip Pearson]

You can use Conditional Formatting from the Format menu to do
this.


"TKT" <[email protected]> wrote in message
news:[email protected]...
> 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

[JE McGimpsey]

One way:

Assuming that cell A1 is selected:

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

In article <[email protected]>,
TKT <[email protected]> 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

[TKT]

Thank you for taking the time to respond....greatly appreciate it! I will
try it
and see how it works. ~TKT


"Chip Pearson" wrote:

> You can use Conditional Formatting from the Format menu to do
> this.
>
>
> "TKT" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[TKT]

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 <[email protected]>,
> TKT <[email protected]> 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
>

[TKT]

Hi JE,

To further complicate my issue, what if I have a drop down list....can I
still set it to recognize the various codes set? Example given below:

F = Fixed (want to reflect blue)
R = Rendering (want to reflect green)
N = Null (want to reflect yellow)
P = Pass (want to reflect grey)

My drop down menu has the options "F", "R", "N" and "P"....once someone
selects "F" or one of the other 3, can it be assigned the various colors
which I've listed above? I am desperately trying to have this automatically
color the cell once the code is selected.

Hope I am making sense....please advise and thanks again! ~TKT


"JE McGimpsey" wrote:

> One way:
>
> Assuming that cell A1 is selected:
>
> CF1: =OR(A1="R", A1="render")
> Format1: <patterns>/<color>
>
> In article <[email protected]>,
> TKT <[email protected]> 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
>

[Max]

See one response to your later post ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--