R
ray963
Hi All,
I am creating a "Data Validation" on "Sheet 1".
The Data for the drop down list is on "Sheet 2" e.g. "YES", "NO".
I have created the drop down list which gives me the drop down "YES" & "NO"
on Sheet 1.
My iquiry is, when I select "YES" on the drop down list it places "YES" in
the cell. I also want the "cell fill colour" to change to "GREEN". Also when
I select "NO" I want the the "cell fill colour" to change to "RED".
Can anyone help me?
I am creating a "Data Validation" on "Sheet 1".
The Data for the drop down list is on "Sheet 2" e.g. "YES", "NO".
I have created the drop down list which gives me the drop down "YES" & "NO"
on Sheet 1.
My iquiry is, when I select "YES" on the drop down list it places "YES" in
the cell. I also want the "cell fill colour" to change to "GREEN". Also when
I select "NO" I want the the "cell fill colour" to change to "RED".
Can anyone help me?