From: "David McRitchie"<DMcRitchie@msn.com><uXNU3.4788$Hc.13304694@news.optonline.net><eHvvkvFK$GA.243@cpmsnbbsa03> 
References: 
Subject: Re: Conditional format
Date: Sat, 6 Nov 1999 08:35:37 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: 
Newsgroups: microsoft.public.excel.misc
Path: cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!cpmsnbbsa04!cpmsnbbsa03
Xref: cppssbbsa01.microsoft.com microsoft.public.excel.misc:63240

Hi Mike,

Condition 1 formula -- pattern Green
=AND($A$1="Y",TRIM($G$1)="")

Condition 2 formula -- pattern No Color
=OR($A$1<>"Y",TRIM($G$1)=""<spammers_suck-mdng@optonline.net>)

You only need   condition 1,  but adding condition 2 will make the
cells beyond the last used cell look better.

HTH,  you can use  ISBLANK($G$1) instead
David McRitchie,  Microsoft MVP - Excel
My Excel Pages:  http://members.aol.com/dmcritchie/excel/excel.htm

Mike D  wrote in message news:uXNU3.4788$Hc.13304694@news.optonline.net...
> In Excel 97 I'm trying to write a conditional format that will check if cell
> A1 contains the letter "Y", and if it does and another cell, G1 is blank the
> format kicks in.  I've used the IF and ISBLANK functions seperately and they
> work but I can't seem to join them.