ExcelBanter - View Single Post - VBA / Changing the colour of cell given an input

[email protected]

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?