Posted to microsoft.public.excel.worksheet.functions

NBVC[_54_] NBVC[_54_] is offline

external usenet poster

Posts: 1

Conditional Format and Highlighting question

Try:

=IF(AND(F9="",G9=""),"No Data",IF(F9=G9,"PASS","FAIL"))

--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111058

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 - Highlighting the whole row	chantique	Excel Worksheet Functions	2	October 18th 08 05:59 AM
Conditional Format Question	will07	Excel Discussion (Misc queries)	1	April 28th 08 08:42 AM
What does Conditional format change when highlighting?	J@Y	Excel Discussion (Misc queries)	5	June 4th 07 08:59 PM
Conditional Format Question	Karl	Excel Discussion (Misc queries)	5	January 11th 07 11:55 PM
Conditional format question	[email protected]	Excel Discussion (Misc queries)	7	September 16th 05 04:15 PM

All times are GMT +1. The time now is 03:13 PM.

About Us

"It's about Microsoft Excel"