Posted to microsoft.public.excel.misc

Missile

external usenet poster

Posts: 11

Conditional Formatting Formula

After some help with Conditional Formatting.
As an example I have the following data in cells B1 & B2;
Cell B1 "Project 1 - Testing"
Cell B2 "Project 2 - Not Issued"
I want the cells containing the words "Not Issued" to be shaded (Green). In
this example that would be "B2".
Also I would like the same shading applied to cells A2, C2 to H2.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
formula for conditional formatting	SandyB	Excel Worksheet Functions	3	May 29th 08 11:38 AM
Conditional Formatting formula	tankerman	Excel Discussion (Misc queries)	2	December 22nd 06 05:34 PM
Conditional Formatting Formula	DHEvans333	Excel Worksheet Functions	1	November 9th 06 08:51 PM
conditional formatting with FORMULA... Please HELP!	Chris M	Excel Discussion (Misc queries)	1	August 20th 05 12:28 AM
conditional formatting with FORMULA... Please HELP!	Chris M	Excel Discussion (Misc queries)	0	August 18th 05 11:51 PM

All times are GMT +1. The time now is 04:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us