Posted to microsoft.public.excel.misc

SandyB

external usenet poster

Posts: 7

conditional formatting OR formula

=OR(C:C="FLAT",C:C ="2FS",C:C ="3FCH")

Above is the formula I am trying, so column C words Flat, 2FS, or 3FCH will
get yellow highlight in another column cell. However, it now highlights the
entire column yellow, regardless of the text I have in column C. What am I
doing wrong?
--
SandyB

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 as a formula	tbsolms	Excel Worksheet Functions	0	March 8th 07 10:49 PM
conditional formatting or formula	CJRolls	Excel Worksheet Functions	5	May 10th 06 06:12 PM
Conditional Formatting Formula	George	Excel Worksheet Functions	1	March 28th 06 04:50 PM
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 12:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us