Posts by Krishnakumar

    Re: Conditional Formatting the Dates


    Hi Mangesh,


    Well, I come up with the following code.




    Kris

    Re: Conditional Formatting the Dates


    Hi Mangesh,


    Thanks for the reply. Your code is for a particular cell. I would like to have an event code and my range will be


    myRange = Range("C7:C" & Range("C65536").End(xlUp).Row)


    Any idea?


    Kris

    Hi All,


    I would like to know how can I conditionally format dates in a cell by VBA.


    for e.g. if the date in a cell:
    <today():red
    =today():lightred
    today()+1:lightyellow
    today()+2:lightgreen
    >today()+2:teal(colorindex=14)


    I have to use this code for a range which is a part of pivot table.
    The range starts from C7


    Any help would be appreciated.


    Kris

    Re: Indian Currency Format


    Hi,


    Here is a contribution from Mr. Yogi Anand and a UDF from parry.
    Custom cell format :
    =REPLACE(TEXT(B2,"##"",""##"",""##"",""##"",""##"",""##"",""###"),1,6-INT((LEN(B2)>3)+(LEN(B2)-4)/2),"")
    By Yogi.


    Here is the UDF by Parry



    Kris