I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.

In B1 type the formula

=IF(A10,"yes","")

In this case I chose the word "Yes" as the word of your choice.

"FC" wrote:

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.

Thanks Teddy-B, but A1 ( or column A) will have different
names or numbers and then B1 ( column B ) will change accordinly.
ej. A1 orange - B1 navels
A2 5228 - B2 apples
A3 grapes - B3 small. Thanks
"Teddy-B" wrote:

In B1 type the formula

=IF(A10,"yes","")

In this case I chose the word "Yes" as the word of your choice.

"FC" wrote:

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.

Sounds like you could use a lookup table and some VLOOKUP formulas in column B.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Sat, 26 May 2007 17:11:02 -0700, FC wrote:

Thanks Teddy-B, but A1 ( or column A) will have different
names or numbers and then B1 ( column B ) will change accordinly.
ej. A1 orange - B1 navels
A2 5228 - B2 apples
A3 grapes - B3 small. Thanks
"Teddy-B" wrote:

In B1 type the formula

=IF(A10,"yes","")

In this case I chose the word "Yes" as the word of your choice.

"FC" wrote:

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.

Thanks Gord Dibben, but all cells in column A will change frecuentely and as
I change them I want B to change accordinly too. Also is too much information
for a dropdown list ( the changing words or numbers ). TX

"Gord Dibben" wrote:

Sounds like you could use a lookup table and some VLOOKUP formulas in column B.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Sat, 26 May 2007 17:11:02 -0700, FC wrote:

Thanks Teddy-B, but A1 ( or column A) will have different
names or numbers and then B1 ( column B ) will change accordinly.
ej. A1 orange - B1 navels
A2 5228 - B2 apples
A3 grapes - B3 small. Thanks
"Teddy-B" wrote:

In B1 type the formula

=IF(A10,"yes","")

In this case I chose the word "Yes" as the word of your choice.

"FC" wrote:

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.

OK forget the DV dropdowns, but the lookup table should work for you.

Unless you are entering words in column A that wouldn't be on any table.

Table on sheet2 in A1:B3 or any range you like.

Column A contains your words to enter.........orange, 5228, grapes

Column B contains your words to appear..........navels, apples, small

In B1 of sheet1 enter =VLOOKUP(A1,Sheet1!$A$1:$B$3,2,FALSE)

In A1 of sheet1 enter orange and see what is returned to B1


Gord

On Sat, 26 May 2007 19:15:00 -0700, FC wrote:

Thanks Gord Dibben, but all cells in column A will change frecuentely and as
I change them I want B to change accordinly too. Also is too much information
for a dropdown list ( the changing words or numbers ). TX

"Gord Dibben" wrote:

Sounds like you could use a lookup table and some VLOOKUP formulas in column B.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Sat, 26 May 2007 17:11:02 -0700, FC wrote:

Thanks Teddy-B, but A1 ( or column A) will have different
names or numbers and then B1 ( column B ) will change accordinly.
ej. A1 orange - B1 navels
A2 5228 - B2 apples
A3 grapes - B3 small. Thanks
"Teddy-B" wrote:

In B1 type the formula

=IF(A10,"yes","")

In this case I chose the word "Yes" as the word of your choice.

"FC" wrote:

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.