VBA / Changing the colour of cell given an input
 

Is there away to change the colour of a cell given a specific input.
Depending on the value a user gives in a cell, I'd like to
correspondingly change the colour.

I am assuming there is a straightforward way to test inputs and
correspondingly change the settings of a cell and ideally a couple of
other cells.

VBA / Changing the colour of cell given an input
 

Format/Conditional Formatting. Select Formula Is, =$A$1=1, then click format
and select your color. When 1 is input into A1, your cell will change color.



" wrote:

Is there away to change the colour of a cell given a specific input.
Depending on the value a user gives in a cell, I'd like to
correspondingly change the colour.

I am assuming there is a straightforward way to test inputs and
correspondingly change the settings of a cell and ideally a couple of
other cells.

VBA / Changing the colour of cell given an input
 

JMB wrote:
Format/Conditional Formatting. Select Formula Is, =$A$1=1, then click format
and select your color. When 1 is input into A1, your cell will change color.



" wrote:

Is there away to change the colour of a cell given a specific input.
Depending on the value a user gives in a cell, I'd like to
correspondingly change the colour.

I am assuming there is a straightforward way to test inputs and
correspondingly change the settings of a cell and ideally a couple of
other cells.



Thank you. That seems to work. Is there anyway to cause the change in
the value of one-cell to change the colour of another cell?

So let's say,

I set A1 = 'Y',

how could I then make A2 change to green?

VBA / Changing the colour of cell given an input
 

don't worry about it...done. using "formula is"

wrote:
JMB wrote:
Format/Conditional Formatting. Select Formula Is, =$A$1=1, then click format
and select your color. When 1 is input into A1, your cell will change color.



" wrote:

Is there away to change the colour of a cell given a specific input.
Depending on the value a user gives in a cell, I'd like to
correspondingly change the colour.

I am assuming there is a straightforward way to test inputs and
correspondingly change the settings of a cell and ideally a couple of
other cells.



Thank you. That seems to work. Is there anyway to cause the change in
the value of one-cell to change the colour of another cell?

So let's say,

I set A1 = 'Y',

how could I then make A2 change to green?

VBA / Changing the colour of cell given an input
 

Seems like you've got it. One other thing just in case you are not aware -
the absolute/relative reference concepts still apply..

If you format A2 using =$A$1 = "Y", the conditional format will always refer
to cell A1. If you use =A1="Y", then copy A2 to B2, B2's format will depend
on B1, not A1.


" wrote:

don't worry about it...done. using "formula is"

wrote:
JMB wrote:
Format/Conditional Formatting. Select Formula Is, =$A$1=1, then click format
and select your color. When 1 is input into A1, your cell will change color.



" wrote:

Is there away to change the colour of a cell given a specific input.
Depending on the value a user gives in a cell, I'd like to
correspondingly change the colour.

I am assuming there is a straightforward way to test inputs and
correspondingly change the settings of a cell and ideally a couple of
other cells.



Thank you. That seems to work. Is there anyway to cause the change in
the value of one-cell to change the colour of another cell?

So let's say,

I set A1 = 'Y',

how could I then make A2 change to green?