Thanks man...! Good work
On Wed, Apr 15, 2009 at 8:07 PM, Harmeet Singh wrote:
> Hi Surya,
>
> See attached file.
> One suggetion, it would be easy to apply conditional formatting if you
> change the format for column A.
>
> On Wed, Apr 15, 2009 at 12:59 PM, Suryaprasad.bv > wrote:
>
>> Hi Guys,
Hi Surya,
As long as your data is in the format provided in your sample file, the
solution in the attached will be ok.
Regards - Dave.
Date: Wed, 15 Apr 2009 12:59:11 +0530
Subject: $$Excel-Macros$$ Color Conditional Formatting
From: suryaprasad...@gmail.com
To: excel-macros@googlegroups.co
Hi
I want excel dumps for certification
advance excel 2007
plz help me???
On Wed, Apr 15, 2009 at 9:58 PM, Harmeet Singh wrote:
> Formula dekh ke chakar aa gaye.hahahahaa
> I must say awesome work.
> Cheers.
>
> On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey wrote:
>
>> Hi Surya,
>>
Formula dekh ke chakar aa gaye.hahahahaa
I must say awesome work.
Cheers.
On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey wrote:
> Hi Surya,
>
> Please find the solution attached. I have tested it also and it is working
> fine.
>
> Note: You may find that some of the time entered by you i
Hi
pl find the file attached, soultion is, first replace "-" with " " (space)
then
put a formula next to date row, that is hour(a1), it will fetch hour from
the date n time part then
apply conditional formatting on hour, if hour is greater then 7 then it will
color the cell.
regards,
Deepak Rawat
Hi Surya,
Please find the solution attached. I have tested it also and it is working
fine.
Note: You may find that some of the time entered by you in the earlier rows
have changed, it is because of the testing done.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 981092974
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
check the article above for color conditional formatting with an example
(steps 3 and 4). Tell me your specific case so that I can tell you what to
keep in the formula or cell value.
On 4/15/09, Suryaprasad.bv w
Hi Surya,
See attached file.
One suggetion, it would be easy to apply conditional formatting if you
change the format for column A.
On Wed, Apr 15, 2009 at 12:59 PM, Suryaprasad.bv
wrote:
> Hi Guys,
>
> Can any one help me on the conditional formatting .
>
> Cheers
> Surya
>
> >
>
--
Than
