Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Conditional Formatting (Excel 2007)

    Iím trying to determine if itís possible to setup a conditional format using
    the icon set for the following conditions: in cell A1 contains a date (e.g.,
    09/30/2008), when the current date is pasted the date in cell A1, I would
    like for a red-flag (icon) to appear beside the date in cell A1. Is this
    possible?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting (Excel 2007)

    Put in B1 the icon you want. change the format to be white text to hide it.

    select B1 and Format - conditional formatting..
    Formula is:
    =INT(A1)=TODAY()
    [Format]
    Set the format as desired (red text / yellow background or red background)
    [ok][ok]

    When A1 contains today's date (changes daily) B1 will be displayed

    Steve
    Steve

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Conditional Formatting (Excel 2007)

    Dear SbDale:

    Welcome to the lounge.

    Not an exact answer to your question but as a work around.

    Why not open a new column next to the data in column A and then use the Excel if statement to find and flag.

    I have attached a sample.
    The date in cell A1 is compared to the dates in the other rows of Column A, Column B will show a Red Mark if any dates are past the date in Cell A1.

    Regards,

    Tom Duthie
    Attached Files Attached Files

  4. #4
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (Excel 2007)

    Thanks for the recommendations, both solutions worked for me.

Posting Permissions

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