conditional formatting that would reflect to different cell

[A_Al]

Is there a conditional formatting that would reflect to (cell) based on (value chosen from drop-down list in different cell)?



Condition : All cells containing the value of (Yes) the next cell will be highlighted in gray and not allow anything to be typed; if (no) the next cell will be highlighted in green, blank and allow you to write comment ((without using if in the next cell)).

 

[etaf]

you can use data validation
Custom
$A2<>"Yes"

also conditional formatting
2 rules
$A2="yes" format grey
$A2="no" format green

Book5
	A	B
1	yes
2	no
3	no
4	yes
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B5	Expression	=$A1="no"	text	NO
B1:B5	Expression	=$A1="yes"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B1:B4	Custom	=$A1<>"Yes"

 

[A_Al]

you can use data validation
Custom
$A2<>"Yes"

also conditional formatting
2 rules
$A2="yes" format grey
$A2="no" format green

Book5
	A	B
1	yes
2	no
3	no
4	yes
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B5	Expression	=$A1="no"	text	NO
B1:B5	Expression	=$A1="yes"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B1:B4	Custom	=$A1<>"Yes"

is it possible to add: if the cell (A2) containing the value of (Yes) the next cell (B2) not allow anything to be typed(block cell); if (no) the next cell allow you to write comment

 

[etaf]

yes , thats what the data validation will do

 

[A_Al]

you can use data validation
Custom
$A2<>"Yes"

also conditional formatting
2 rules
$A2="yes" format grey
$A2="no" format green

Book5
	A	B
1	yes
2	no
3	no
4	yes
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B5	Expression	=$A1="no"	text	NO
B1:B5	Expression	=$A1="yes"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B1:B4	Custom	=$A1<>"Yes"

solved, thanks.

 

[etaf]

you are welcome