How do I setup Conditional formating for a cell that has a yes or.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a cell (C8) turn blue when cell (B5) is YES and have no
color if cell (B5) is NO. Any suggestions.
 
Select C8. Under CF, choose Formula Is, and put:

=B5="Yes"

and press the Format radio button. Choose blue on the
Pattern tab.

HTH
Jason
Atlanta, Ga
 
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

Conditionally protect a cell 2
Conditional Formatting ROW not working 6
Change Text Color in one cell based upon entry in referenced cell 3
Excel Conditional Formatting 1
How to determine the value within specific cell position? 5
Excel VBA 1
conditional format to affect a different cell 3
15 minutes early 5

Back
Top