| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating based on another cell | Excel Discussion (Misc queries) | |||
| Conditional formating - cell protection | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Linear Mode
