; msg03275
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

msg03275

VIEWS: 2 PAGES: 2

  • pg 1
									                                           Re: to Dave Peterson

Re: to Dave Peterson

Source: http://www.tech−archive.net/Archive/Excel/microsoft.public.excel.misc/2005−09/msg03275.html



      • From: "Ross" <ssor@xxxxxxxxxxxx>
      • Date: Sun, 18 Sep 2005 15:45:19 GMT

Dave,
Yeah, that fixed it. What was in the box was this ="J1="" I had an extra
quote in there somehow. My bad. :)
Thanks a million for your help
Ross
"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:432CC81D.B59BB4EB@xxxxxxxxxxxxxxxxxxx
> This is a followup to the question about using conditional formatting on
> column
> J to indicate the empty cells.
>
> The two formulas were =isblank(J#) and =len(J#) for the cell that didn't
> get
> formatted correctly.
>
> I'm gonna guess that there was a mistake in the way Format|Conditional
> formatting was applied ('cause those results look ok).
>
> Select J1.
> Hit ctrl−spacebar
>
> Now hit format|conditional formatting.
> You should see Formula is: =J1=""
> and if you click on the format button, then pattern Tab|then select a nice
> fill
> color.
>
> Make sure you ok your way out.
>
> Most of this has already been posted, but double checking/redoing can't
> hurt.
>
> Ross wrote:
>>
>> Dave,
>> it appears that when I reply to your posts that my email gets bumped
>> and I
>> get that mail deilivery subsytem message. Here were what came when I
>> entered those functions, supplying the address of two separate but blank


Re: to Dave Peterson                                                                                  1
                                         Re: to Dave Peterson
>> cells in the column.
>> I get True in the first and 0 in the second
>>
>> Ross
>>
>> −−−−− Original Message −−−−−
>> From: "Dave Peterson" <petersod@xxxxxxxxxxxxxxxx>
>> Newsgroups: microsoft.public.excel.misc
>> Sent: Saturday, September 17, 2005 6:59 PM
>> Subject: Re: Blank cell revisited
>
> −−
>
> Dave Peterson


.



     • References:
            ♦ Re: to Dave Peterson
                    ◊ From: Dave Peterson

     • Prev by Date: Re: basic question on typing names on spreadsheet− problem
     • Next by Date: more conditional formatting
     • Previous by thread: Re: to Dave Peterson
     • Next by thread: Re: set up a macro to delete characters in each cell of a column
     • Index(es):
            ♦ Date
            ♦ Thread




Re: to Dave Peterson                                                                      2

								
To top