Name: Upendra Singh
Tip: color Every Alternate Row in data with conditional Formatting (without
Macro)
1. Select the data you want to Format.
2. Go to Conditional Formatting.
3. In the first box, Select “Formula is” and type the formula :
=MOD(ROW()-1,1*2)+1>1.
4. Set
@googlegroups.com
Subject: $$Excel-Macros$$ Re:Options
dear upendra
i am trying it out but i am unable 2 get the thing can attach
an excel sheet & show with the example
On Sat, Jun 20, 2009 at 12:23 AM, vinay keni wrote:
dear upendra
On Fri, Jun 19, 2009 at 8:39 PM, Upendra S
on
You can use this freeze function for many other applications, depending on your
use.
Chees,
Bakul
--- On Fri, 6/19/09, Bakul Patel wrote:
From: Bakul Patel
Subject: $$Excel-Macros$$ Re:Options
To: excel-macros@googlegroups.com
Date: Friday, June 19, 2009, 7:10 PM
Hi Friend
dear upendra
i am trying it out but i am unable 2 get the thing can attach
an excel sheet & show with the example
On Sat, Jun 20, 2009 at 12:23 AM, vinay keni wrote:
> dear upendra
>
>
> On Fri, Jun 19, 2009 at 8:39 PM, Upendra Singh <
> upendrasinghsen...@gmail.com> wrote:
>
>>
ul =PROPER(A1) Bakul
Cheers,
Bakul
--- On Fri, 6/19/09, Upendra Singh wrote:
From: Upendra Singh
Subject: $$Excel-Macros$$ Re:Options
To: excel-macros@googlegroups.com
Date: Friday, June 19, 2009, 8:09 AM
Hi Friends,
Name : Upendra Singh
TIP : Hide Data i
Hi Friends,
Name : Upendra Singh
TIP : Hide Data in Cell or Worksheet from praying Eyes
ðSelect the range you want to hide.
ðGo To Format=>Number=>Custom
ðIn the type Box, type three colon (;;;) and press enter.
ðThe data where the above formatting is applied wi
This is something really new thanks for the same
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rajesh Kunder
Sent: 19 June 2009 09:27 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$Options
Hi,