Posted to microsoft.public.excel.worksheet.functions

Melvin Tang[_2_] Melvin Tang[_2_] is offline

external usenet poster

Posts: 4

conditional formatting in an IF function?

I have a set of specified values in two columns in worksheet 1: M1 = 1, M2 =
2, M3 = 3 etc... in Worksheet 2, i have two columns: Class (M1 to M10) and
Value (1 to 10). How do I, in Worksheet 2, highlight the cells that don't
match the specified value of the class (ie. M1 = 5)?

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
Conditional Formatting or IF function	Danny	Excel Worksheet Functions	3	February 26th 08 12:10 AM
Conditional formatting with IF function	Michael	Excel Discussion (Misc queries)	1	May 29th 07 05:38 AM
Help on a function with Conditional Formatting	nemadrias	Excel Worksheet Functions	1	August 10th 06 08:55 PM
Conditional Formatting (IF function)	Neo1	Excel Worksheet Functions	5	March 2nd 06 10:38 PM
Conditional formatting and If function?	dond	Excel Discussion (Misc queries)	4	July 22nd 05 01:19 PM

All times are GMT +1. The time now is 02:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us