You Can use conditinoal formatting
On Wed, Jul 13, 2011 at 4:05 PM, Jorge Marques wrote:
> Hi friend, i don´t understand exactly what you want, but if you want to
> highlight the entire row that has the negative numbers like this, or do you
> want it to copy to another column the year and negati
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Wednesday, July 13, 2011 4:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ HELP urgent
Hi friend, i don´t understand exactly what you want, but if you want to
highlight the entire
Hi friend, i don´t understand exactly what you want, but if you want to
highlight the entire row that has the negative numbers like this, or do you
want it to copy to another column the year and negative value?
Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 2009
20 2011 29
Please attach a sample file with more explaination..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Puneet Jain
Sent: Wednesday, July 13, 2011 12:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HELP urgent
Guys
Need Help.
its Not working getting the wrong emaild id s
Hi Ashish the formula which u have provieded its working somewht but "out 10
geeitn the id for 2 employees id "
Thanks,
On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR wrote:
> HI,
> i think solved your quetions.
> otherwise revert me.
> Regards
> Pra
hope you will get most of ids from these formula's
c2 = VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",B:B,1,0)
d2 = VLOOKUP("*"&RIGHT(A2,LEN(A2)-FIND("~",SUBSTITUTE(A2,"
","~",LEN(A2)-LEN(SUBSTITUTE(A2," ",""),B:B,1,0)
On Tue, Jul 5, 2011 at 9:58 PM, ICWAI Help wrote:
> Search the employee name in
;>>
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
>>> *Sent:* Thursday, June 02, 2011 4:21 PM
>>>
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
>> *Sent:* Thursday, June 02, 2011 4:21 PM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !
On Behalf Of *karan 1237
> *Sent:* Thursday, June 02, 2011 4:21 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>
>
>
> Thnx a lot Rajan but I want one more thing that is it possible to make
> input box character l
t;
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta
> *Sent:* Wednesday, June 01, 2011 8:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>
>
>
> *Dear кαя
Thnx for this vishal but I dnt wnt to prtect sheet as you think I want to
protect sheet in different way. I hope you'v seen that excel file which I'v
attached. I made a combo box & I want to protect it like : I chose a name
from combobox like Dharmendra mishra & now I want that when I choose name
*Dear кαяαηη,*
*Greetings for the day!!!*
*to protect your sheet or workbook go to review pane in office 2007, then
protect sheet, then limit of protection. by doing this u can protect ur
project with a password.*
**
Regards
Vishal Gupta
On Wed, Jun 1, 2011 at 3:58 PM, karan 1237 wrote:
>
> H
Hi ,
Use 'reset print area", or unhide the hiden rows, freeze panes and try it
once .
i hope this wil help you
Ravi Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and lin
13 matches
Mail list logo