Posted to microsoft.public.excel.worksheet.functions

carl

Posts: n/a

Conditional Format Question

My table looks like this:

ID
50 50
60 60
355 355
549 549
642 642
910 910
912 912
913 913
914 914
918 918
919 919
931 931
937 937
947 947
958 958
#N/A 969
980 980
#N/A 989

ColA has a formula formula in it. Is it possible to use the conditional
formating function on ColB to highlight the ID's that correspond to the
#N/A's ?

Thank you in advance.

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 format in merged cells.	MMAC	Excel Discussion (Misc queries)	1	March 6th 06 11:33 AM
Conditional Format	Graham Haughs	Excel Discussion (Misc queries)	4	February 5th 06 02:42 PM
Conditional format problem	PJ	Excel Discussion (Misc queries)	2	March 11th 05 02:05 PM
make a conditional format the default	Fred Evans	Excel Discussion (Misc queries)	3	December 6th 04 05:01 AM
Conditional Format With SUMIF	Minitman	Excel Worksheet Functions	3	November 1st 04 02:58 PM

All times are GMT +1. The time now is 04:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us