+ Reply to Thread
Results 1 to 6 of 6

High Lighting Current Date In employee Attendance

  1. #1
    Registered User
    Join Date
    06-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    23

    High Lighting Current Date In employee Attendance

    Dear Friends,

    Please find the attachment

    how to high lighting the current date in employee attendance.

    Regards,

    Sanjeevi
    Attached Files Attached Files
    Last edited by sanjeevi888; 07-03-2012 at 11:50 AM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: High Lighting Current Date In employee Attendance

    HI Sanjeev,

    You can use the below formula in conditional formatting :-

    =A5=TODAY()

    where A5 is the cell selected when I applied the CF on entire row... see attached. thanks.

    Example 9.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    06-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: High Lighting Current Date In employee Attendance

    Please find the attachment...
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: High Lighting Current Date In employee Attendance

    Hi Sanjeevi888,

    I have already provided the solution in my post#2... Did you got that...?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    06-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: High Lighting Current Date In employee Attendance

    Thank... U dilipandey bro i clear about this code..
    Thank U very much

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: High Lighting Current Date In employee Attendance

    You are welcome Sanjeev..

    Please mark this thread as [SOLVED].. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1