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

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

Greetings from New Zealand

"david" wrote in message
...
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