+ Reply to Thread
Results 1 to 4 of 4

Display Icon if date entered and a different icon if no date

  1. 01-29-2024, 08:24 PM #1
    Mr.Bean
    Mr.Bean is offline
    Registered User
    Join Date
    10-06-2017
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2016
    Posts
    19

    Display Icon if date entered and a different icon if no date

    Hello,

    I would like to have cell A2 display an icon based on whether or not a completion date has been entered into cell I2.

    I have typed =IF(ISBLANK(I2),"0","3") into cell A2 and then set Conditional Formatting for Cell A2 to display a check mark if cell value is >= 3 and an x if < 3 and = 0

    The formula works to change the value of A2 based on a date entered into I2. The Continental Formatting works if I put a number in A2, but the two don't work together.

    A2 is formatted to display a number.

    Typing =J2 into A2 also works, unless J2 gets it's value from the IF formula above. I don't know what I am doing wrong.
    Attached Files Attached Files
    Last edited by Mr.Bean; 01-29-2024 at 08:26 PM.
    Reply With QuoteRegister To Reply
  2. 01-29-2024, 08:42 PM #2
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Display Icon if date entered and a different icon if no date

    I think I understood your post.

    1. Add =IF(ISBLANK(I2), 0, IF(ISNUMBER(I2), 3, "0")) to A2
    2. Edit cond formatting
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-30-2024, 10:53 AM #3
    Mr.Bean
    Mr.Bean is offline
    Registered User
    Join Date
    10-06-2017
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2016
    Posts
    19

    Re: Display Icon if date entered and a different icon if no date

    Thank you russkris, that did the trick. Much appreciated.
    Reply With QuoteRegister To Reply
  4. 01-30-2024, 08:02 PM #4
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Display Icon if date entered and a different icon if no date

    Glad to have helped.

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Annual Due Date + Conditional Formatting - Icon Set
    By LEstelle93 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2021, 11:48 PM
  2. Annual Due Date + Conditional Formatting - Icon Set
    By LEstelle93 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-31-2021, 11:48 PM
  3. [SOLVED] Can we change the icon other than Excel's own green icon with an X on it?
    By ImranBhatti in forum Excel General
    Replies: 3
    Last Post: 12-31-2016, 04:24 AM
  4. Set overlay icon and progress icon in win7 taskbar using VBA
    By optikap in forum Microsoft Windows Help
    Replies: 0
    Last Post: 03-26-2014, 04:39 PM
  5. Changing Excel Icon so that it can be E-mailed with selected icon
    By mssbrgmn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2013, 12:09 PM
  6. Change File Icon and/or Title Bar Icon
    By Casedias in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-17-2011, 07:35 PM
  7. [SOLVED] How do I set up a calendar icon on a worksheet to choose the date
    By Calendar icon in a spreadsheet in forum Excel General
    Replies: 1
    Last Post: 01-10-2006, 12:15 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1