Conditional Formatting based on adjacent cell value

  • Thread starter Thread starter Bill Meacham
  • Start date Start date
B

Bill Meacham

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:
 
That works. Thanks!

Marcelo said:
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:
Click to expand...
 
thanks for the feedback


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



"Bill Meacham" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format (exclude 0) 1
Help needed 0
conditional formating for the whole row, based on one cell value 2
Need HELP!! IF OR formula driving me crazy!!!! 8
Conditional Formatting 4
Sum up values from adjacent column 4
Two conditions in one cell. Help needed ASAP 3
Display maximum value of matching values in a different column 7

Back
Top