+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting

  1. #1
    Registered User
    Join Date
    02-08-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    13

    Conditional Formatting

    I have this question in a mock exam paper:

    "use conditional formatting to colour cell F27 green if it equals cell C9 or red if not"

    [/B]I know how to do basic conditional formatting but not sure how when there is an either or argument.
    Can anyone help please?

  2. #2
    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
    52,242

    Re: Conditional Formatting

    What have you tried, so far?

    We wont do your homework for you, but we will assist in guiding you.

    1 think to note is that CF only works on TRUE (1) or FALSE (0) returns, so you would need to structure a formula that would give TRUE based on those arguments.
    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

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Conditional Formatting

    Is this some kind of homework?

  4. #4
    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
    52,242

    Re: Conditional Formatting

    Quote Originally Posted by arthurbr View Post
    Is this some kind of homework?
    It appears that way, hence my instruction.

  5. #5
    Registered User
    Join Date
    02-08-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Conditional Formatting

    This is not my homework, it is one of many revision papers for an exam that they give us to practice with.

    I have tried going through the conditional formatting tab and the various options under there and can only make the green colour work when the two cells equal the same but if I change the number so it doesn't equal the same I can't seem to find an option to make the cell red.

    I have also gone back to my study books but can't find anywhere it tells you how to deal with the two instructions, only one.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,870

    Re: Conditional Formatting

    I don't think that it will be too large a hint to say that the question doesn't state that you are limited to using one rule, only that you are to use conditional formatting.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  7. #7
    Registered User
    Join Date
    02-08-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    13
    Quote Originally Posted by JeteMc View Post
    I don't think that it will be too large a hint to say that the question doesn't state that you are limited to using one rule, only that you are to use conditional formatting.
    Thank you, Iíve tried mixing a formula along with conditional formatting but just cant make it work

+ 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] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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