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?
--
ray963

Check into Conditional Formatting:
If you are only basing it on the current cell value
Leave condition 1 drop down as Cell Value is, change the second drop down
to: equal to. And type ="YES" in the final box. Then click on format to
change your format. Click add to add a second condition for NO.

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"ray963" wrote:

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?
--
ray963

Use Conditional Formatting. Format - conditioanl Formatting...

You will need 2 conditions. One where the cell value is Yes and a second one
where the cell value is No.
--
HTH...

Jim Thomlinson


"ray963" wrote:

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?
--
ray963

Use conditional formatting.

Assume A1 contains the drop down list
Select cell A1
Goto the menu FormatConditional Formatting
Condition 1
Select the Formula Is option
Enter this formula in the box on the right:
=A1="Yes"
Click the Format button
Select the Patterns tab
Select a shade of GREEN
OK

Click the Add button

Condition 2
Select the Formula Is option
Enter this formula in the box on the right:
=A1="No"
Click the Format button
Select the Patterns tab
Select a shade of RED
OK out

--
Biff
Microsoft Excel MVP


"ray963" wrote in message
...
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?
--
ray963