That works. Thanks!

"Marcelo" wrote:

Hi

Format | Conditional Format

Change to Formula is and use:

=B6="Yes"

format as you need.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bill Meacham" escreveu:

I want to highlight cell A6 if cell B6 has the value "Yes". How do I do it?