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

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?

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?

thanks for the feedback


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



"Bill Meacham" escreveu:

> 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?