Active Cell Formatting

[DKolev]

Guys, I have the following problem:

I want the user to be able to input values between 1-5 (for example) in certain cells, and based on the number chosen, the same active cell to return different text. I don't want to use dropdown menu or any Macros. Is there any way to do that with conditional formatting?

Thanks,

D.

[alansidman]

How about specific examples of what you wish. ie. Enter 1 in A1 and X appears in B1. Help us to help you by giving us enough information to offer a solution.

[DKolev]

Hey - thanks for the reply. The whole action is taking place in one cell - A1. I want the entries to change as below:

user inputs 1 - cell shows "Hello"
user inputs 2 - cell shows "New York"
user inputs 3 - cell shows "Bye"

You think it is possible?

[Norie]

You can't change the value of a cell with conditional formatting, or formulae.

If you want to change the value in cell based on the user input in the cell you would need to use VBA.

For example, with this code in a worksheet module entering 1, 2 or 3 in the range A1:A10 would convert the input to the corresponding terms you mention.

Please Login or Register  to view this content.

[DKolev]

Thanks. Code stopped working, though? Numbers don't change anymore - any idea why this might have happened?

[Norie]

How did you implement the code?

[DKolev]

yeah, it was working up to one point, then it stopped?

[DKolev]

Code breaks when you clear the contents of the cells. After that, it doesn't work anymore.

[DKolev]

And the reason for that is when you select multiple cells, the code cannot calculate the "target" value.... any ideas?

[DKolev]

Can anyone please help?