+ Reply to Thread
Results 1 to 4 of 4

Need help creating formula for conditional icons

  1. #1
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    122

    Angry Need help creating formula for conditional icons

    Hi all,

    So I'm creating a worksheet for work, and I'd like to automate some check-boxes so that if the following two columns have ANYTHING written in them, the checkbox automatically gets ticked. I should note I am trying to accomplish this by creating an icon rule that creates a checkmark for anything 1 and above, and an X for anything that equals 0. Then in the cell itself (A1), I'm am writing the equation. The problem is that my equation seems to be overruling the rule, so I see "1" as opposed to my checkmark.

    Hope this makes sense. Here is my equation in the cell:
    =IF(AND(H4<>"", K4<>""), "1", "0")


    Here it what I want to happen, written in plain english:
    IF A1 = 1, Checkmark
    IF A1 = 2, X

    IF B1 and C1 are BLANK, A1=1, otherwise, A=0
    Last edited by Keegan1116; 02-19-2020 at 03:08 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Need help creating formula for conditional icons

    You need to remove the quotes from the numbers, otherwise they are text
    =IF(AND(H4<>"", K4<>""), 1, 0)

  3. #3
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    122

    Re: Need help creating formula for conditional icons

    Yessssssss. Thank you so much.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Need help creating formula for conditional icons

    You're welcome & thanks for the feedback

+ 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. Conditional formatting with icons
    By myoung76 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2018, 08:52 AM
  2. [SOLVED] Conditional Format Icons
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-11-2018, 02:19 AM
  3. Conditional Formatting with Icons
    By lanespoli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2017, 02:35 AM
  4. Conditional Formatting Icons
    By hlb129 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2012, 10:12 AM
  5. use 3 icons in conditional formatting by formula
    By theghost in forum Excel General
    Replies: 4
    Last Post: 02-14-2012, 12:46 PM
  6. creating icons to use in excel draw
    By excelname in forum Excel General
    Replies: 2
    Last Post: 12-03-2009, 10:40 AM
  7. Excel 2007 : Conditional Formatting with Icons
    By ChrisF79 in forum Excel General
    Replies: 0
    Last Post: 08-13-2008, 01:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1