Enable and disable a cell based on a combination

**Tandrima** · 05-25-2012, 05:41 AM

Hi All,

Please help me with this:

I have a worksheet with 2 columns (say Col1 and Col2). Col2 has 2 list values "Yes" and "No".
Case1. If col2 value is Yes, i need to allow entry into col1 and the corresponding Col1 cell should be filled with green in this case.
Case2. If col2 value is No, I need to restrict entry into Col1 and the corresponding Col1 cell should be filled with yellow color in this case.

Can anyone plaese help me here?

Thanks a lot in advance!!!

Cheers,
Tandrima

**JBeaucaire** · 05-25-2012, 06:06 AM

You will use two different features for each need. Assuming column 2 is B and column 1 is A

1) Color a cell based on the value in another cell on the same row.

If you need to color column A based on the values in column B:

a) highlight column A
b) go to Home > Conditional Formatting > New Rule > Use a formula > Edit the Rule Description
c) Formula is: =B1="yes"
Format...Fill: Green
OK > OK

d) go to Home > Conditional Formatting > New Rule > Use a formula > Edit the Rule Description
c) Formula is: =B1="no"
Format...Fill: Red
OK > OK

2) Lock a cell for data entry based on the value in another column on same row

a) Highlight column A
b) go to Data > Data Validation and apply these setting:

Allow: Custom
Source: =B1<>"no"

**Tandrima** · 05-25-2012, 12:19 PM

Hi,

Thanks a lot for the solution.
The first option works:
1) Color a cell based on the value in another cell on the same row.

But the second option does not.

Please help.