Cell color

A

Alex Simic

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
 
A

Alex Simic

Thanks,
It's working.
Kind regards, Alex

Max said:
If it's up to 3 colors, try normal conditional formatting ..

Select col B

Click Format > Conditional Formatting
Under Condition 1, make the settings as:
Formula is| =AND(A1<>"",A1=0)
Click Format button > Patterns tab > Green > OK

Repeat to add Conditions 2 and 3 with the formulas / fill colors
Cond2: =A1=1, Red
Cond3: =A1=2, Blue (say)

Click OK at the main dialog

Test it by entering the values 0, 1, 2 in various cells in col A
The fill color in col B will be triggered accordingly
--
Rgds
Max
xl 97
Click to expand...
 
Top