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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I setup Conditional formating for a cell that has a yes or. (https://www.excelbanter.com/excel-discussion-misc-queries/20723-how-do-i-setup-conditional-formating-cell-has-yes.html)

Jerry at ECS

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

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.

Jason Morin

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

-----Original Message-----
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.
.

All times are GMT +1. The time now is 01:32 AM.