+ Reply to Thread
Results 1 to 8 of 8

conditional if statement

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    NY
    MS-Off Ver
    2007
    Posts
    17

    conditional if statement

    Hello

    IDK if this can be done but I'm looking to have a cell that has 3 conditional formatting settings
    1) If cell one is blank and cell 2 is FALSE (checkbox) then color of cell is white.
    2) If cell one is >1 and cell 2 is FALSE (checkbox) then color of cell 1 is red.
    3) If cell one is >1 and cell 2 is TRUE (checkbox) then color of cell 1 is green.

    Thanks in advanced
    MCB

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: conditional if statement

    more than likely, the conditional formatting feature in the interface can do what you want.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,883

    Re: conditional if statement

    Quote Originally Posted by vba_php View Post
    more than likely, the conditional formatting feature in the interface can do what you want.
    Perhaps you could explain to the OP how to do that, in case they dont know?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: conditional if statement

    Quote Originally Posted by FDibbins View Post
    Perhaps you could explain to the OP how to do that, in case they dont know?
    well I apologize for that Dibbins. But I like to help folks out by giving them the first steps with regard to semi-simple solutions, for the purpose of them figuring it out and feeling good about themselves so they can do it next time and learn as they go. But, as you say, which might be a good idea....

    Warrior,

    the attached images should represent what you would do in order to accomplish your goal. Do these help?

    1) all rules applied to one cell
    2) how you write a double condition for one cell
    3) how you link a checkbox to a cell
    4) result of doing this same work on 3 different cells
    Attached Images Attached Images

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,883

    Re: conditional if statement

    While I fully endorse the "give a fish - teach how to fish" philosophy, the majority of members are new/have low excel formula/vba skills. As such, it is perhaps better to err on the side of caution and, until they say otherwise, accept that a low skill set exists.

    Thanks for the very nice explanation

  6. #6
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: conditional if statement

    Quote Originally Posted by FDibbins View Post
    While I fully endorse the "give a fish - teach how to fish" philosophy, the majority of members are new/have low excel formula/vba skills. As such, it is perhaps better to err on the side of caution and, until they say otherwise, accept that a low skill set exists.
    thanks for the guidance Dibbins. I will change accordingly. But it doesn't change the fact that there really is no way to know who is experienced and who isn't, other than reading their messages. I will do my best though.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,883

    Re: conditional if statement

    I totally agree that at 1st glance, you could either talking to a world grand master, or someone who is still looking for the "any Key to continue" key, so dumb it down until they prove they have a higher skill set

  8. #8
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: conditional if statement

    Quote Originally Posted by FDibbins View Post
    so dumb it down until they prove they have a higher skill set
    hey no problem! but I would be careful if I were you, about saying dumb it down. I don't think the person who asked the question in this thread would like that too much.

+ 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] Conditional Statement for Negative Numbers inside a Conditional Formula
    By kuzniak in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-18-2015, 11:17 PM
  2. If Or Conditional Statement Help
    By raek718 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2015, 04:01 PM
  3. Conditional Statement
    By kwaggoner321 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2013, 10:36 PM
  4. Conditional IF Statement
    By companygeek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2011, 10:21 PM
  5. Excel 2007 : Conditional without using the IF statement
    By Solihull in forum Excel General
    Replies: 6
    Last Post: 03-13-2011, 05:59 PM
  6. Conditional statement
    By captedgar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 07:17 AM
  7. Conditional if statement
    By Theresa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2005, 02:08 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