Conditional formating

[Guest]

I am trying to figure out a way to make an entire row change colors if a
certain value in the column is a specific answer. For example, i have three
different columns with information in them and the 4th column is a yes or no
answer. If the user answer no in the column, I want the entire row that they
answer now in to change to red font. I know how to make the answer no change
to red by using conditional formating....here is an example.....
Truck Load Driver Run Complete
1 Ferrous Bob no
2 Non Drew yes
3 Mixed Ben no
i didnt know if anyone had any idea on maybe a vb code that will do it for
me or something....thanks

 

[Bill Kuunders]

select the whole range ..say .a1 to d100
<format><conditional format> use the formula =$D1="no"
and set your format

Greetings from New Zealand