+ Reply to Thread
Results 1 to 4 of 4

need blinkg cell if condition fulfil

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    need blinkg cell if condition fulfil

    see below screnn shot
    Capture.JPG

    IN T16 there is O/S AND IN L16 THERE IS A DATE

    what i want is
    IF IN L16 DATE IS TODAYS DATE OR 1ST UPCOMING DATE AND IN T16 THERE IS O/S THEN L16 SHOULD BLINK with Orange colour
    and IF DATE IS POST DATED AND T16 IS O/S THEN L16 SHOULD BLINK WITH Dark Red Colour

    is this possible
    if not make it simple
    if there is O/S IN T16 THEN L16 SHOULD BLINK WITH COLOUR\

    FILE ATTACHED HERWITH FOR REFERENCE
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: need blinkg cell if condition fulfil

    Your description matches neither the image nor the spreadsheet.

    "IN T16 there is O/S AND IN L16 THERE IS A DATE"

    There are no dates in column L.
    Column L clearly states in the image (and spreadsheet) it is a column of Cheque numbers not dates.
    L16 contains the word PENDING

    Do you mean column M ?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: need blinkg cell if condition fulfil


    As blinking cell does not exist in Excel …

  4. #4
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    Re: need blinkg cell if condition fulfil

    yes its M which is date coulum

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Color a cell If 2 other cells meet condition, undo cell color if third cell meet condition
    By aftbrah in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-28-2016, 01:17 AM
  2. Extracting rows that fulfil a criteria
    By adamlamping in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-30-2016, 09:02 AM
  3. Lookup of an Item across markets to fulfil orders
    By Nicole Matthews in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2015, 10:45 AM
  4. Prevent saving of excel if certain condition not fulfil
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2014, 03:41 AM
  5. Replies: 1
    Last Post: 06-19-2013, 12:49 AM
  6. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  7. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 PM

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