Hi Micheal

if you Want to aply conditional formating to column b ,Select range b2:b500
then go to Format- conditional FOrmating-Formula is =a2="apple"

and select format which you wants to apply

"Michael" wrote:

A B

Apple