Conditional Formatting if cell contains 1

[vanther]

Hello, I have a little question , on how do I highlight a certain cell like for example.

	A	B	C	D
1	FIRST NAME	MIDDLE NAME	LAST NAME	VALUE
2	JOHN	DANER	CANRES	1

<tbody>
</tbody>

as you can see table above, if the value contains "1" , the names (first,middle,last) should be highlighted.

Can anyone help me, because I am new in conditional formatting... Im out of guesting formula.. ^^

 

[VoG]

Select A2:C down as far as needed. Use the CF formula

=$D2=1

then set the format as required.

 

[TheCman81]

Highlight your range (not your headers)

Go to conditional formatting - with formulam and input the following =$D2=1

Set your fill colour to whatever you want and hit ok