conditional formatting the whole row

[lezawang]

Hi
I want to highlight the whole row if the cell in column D corresponding to that row is = "no show". So if D3="no show" then Row 3 will be highlighted to yellow for example.

What I did, I highlighted the whole sheet, then went to CF-->Formula and wrote

D1="no show"

but that only highlight the first cell A1.

Any idea please. Thank you so much.

 

[lezawang]

Got it
[FONT=&quot]I did
$D1="no show"

Thank you so much
[/FONT]