Cell color
 

Dear colleagues,



What is the easiest solution to the following problem?



Depending of what I choose in the list of the cell in the first column the
cell in the column 2 (same row) changes the color. This should work
independently for all rows.



e.g. Choosing 1 from the list in cell column 1 changes automatically the
cell in the same row in column 2 to red (0 e.g. to green)



I am looking forward for some hints.



Thanks Alex

Cell color
 

This depends on how many options you have in column A. If 3 or less then
you could just use inbuilt excel conditional formatting - look it up in
excel help.

If more than three options you could use a sheet change event in VBA but
you would need to give a bit more detail as to what the options are.

Hope this helps
Rowan

Alex Simic wrote:
Dear colleagues,



What is the easiest solution to the following problem?



Depending of what I choose in the list of the cell in the first column the
cell in the column 2 (same row) changes the color. This should work
independently for all rows.



e.g. Choosing 1 from the list in cell column 1 changes automatically the
cell in the same row in column 2 to red (0 e.g. to green)



I am looking forward for some hints.



Thanks Alex

Cell color
 

Dear Rowan,

I use only two options.
kind regards,
Alex

"Rowan" wrote in message
...
This depends on how many options you have in column A. If 3 or less then
you could just use inbuilt excel conditional formatting - look it up in
excel help.

If more than three options you could use a sheet change event in VBA but
you would need to give a bit more detail as to what the options are.

Hope this helps
Rowan

Alex Simic wrote:
Dear colleagues,



What is the easiest solution to the following problem?



Depending of what I choose in the list of the cell in the first column
the
cell in the column 2 (same row) changes the color. This should work
independently for all rows.



e.g. Choosing 1 from the list in cell column 1 changes automatically the
cell in the same row in column 2 to red (0 e.g. to green)



I am looking forward for some hints.



Thanks Alex

Cell color
 

In that case just use conditional formatting. Select column B so that B1
is the activecell (it should be white and you should see B1 in the Name
Box on the Formula Bar). Then from the menus FormatConditional Formatting.
Select "Formula is" and enter =A1=1. Set the desired formatting by
clicking on the Format button eg Red font.
Then click on Add
Select "Formula is" and enter =A1=0. Set the desired formatting eg Green
font.
click OK

Regards
Rowan


Alex Simic wrote:
Dear Rowan,

I use only two options.
kind regards,
Alex

"Rowan" wrote in message
...

This depends on how many options you have in column A. If 3 or less then
you could just use inbuilt excel conditional formatting - look it up in
excel help.

If more than three options you could use a sheet change event in VBA but
you would need to give a bit more detail as to what the options are.

Hope this helps
Rowan

Alex Simic wrote:

Dear colleagues,



What is the easiest solution to the following problem?



Depending of what I choose in the list of the cell in the first column

the

cell in the column 2 (same row) changes the color. This should work
independently for all rows.



e.g. Choosing 1 from the list in cell column 1 changes automatically the
cell in the same row in column 2 to red (0 e.g. to green)



I am looking forward for some hints.



Thanks Alex

Cell color
 

Excellent, Thanks,ALex
"Rowan" wrote in message
...
In that case just use conditional formatting. Select column B so that B1
is the activecell (it should be white and you should see B1 in the Name
Box on the Formula Bar). Then from the menus FormatConditional
Formatting.
Select "Formula is" and enter =A1=1. Set the desired formatting by
clicking on the Format button eg Red font.
Then click on Add
Select "Formula is" and enter =A1=0. Set the desired formatting eg Green
font.
click OK

Regards
Rowan


Alex Simic wrote:
Dear Rowan,

I use only two options.
kind regards,
Alex

"Rowan" wrote in message
...

This depends on how many options you have in column A. If 3 or less then
you could just use inbuilt excel conditional formatting - look it up in
excel help.

If more than three options you could use a sheet change event in VBA but
you would need to give a bit more detail as to what the options are.

Hope this helps
Rowan

Alex Simic wrote:

Dear colleagues,



What is the easiest solution to the following problem?



Depending of what I choose in the list of the cell in the first column

the

cell in the column 2 (same row) changes the color. This should work
independently for all rows.



e.g. Choosing 1 from the list in cell column 1 changes automatically
the
cell in the same row in column 2 to red (0 e.g. to green)



I am looking forward for some hints.



Thanks Alex