Jason Morin

Posts: n/a

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating based on another cell	SMac	Excel Discussion (Misc queries)	5	March 10th 05 07:17 PM
Conditional formating - cell protection	Bdavis	Excel Discussion (Misc queries)	0	February 11th 05 09:15 PM
Conditional Formating	csfrolich	Excel Discussion (Misc queries)	2	January 17th 05 02:07 PM
Conditional Formating	Aviator	Excel Discussion (Misc queries)	1	January 12th 05 05:37 PM
How to do a conditional formatting based on an adjacent cell	Confused	Excel Discussion (Misc queries)	2	January 10th 05 09:55 PM

All times are GMT +1. The time now is 12:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us