+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting - If Cell = Cell Green If not Red

  1. #1
    Registered User
    Join Date
    06-29-2016
    Location
    United Kingdom
    MS-Off Ver
    2013
    Posts
    6

    Conditional Formatting - If Cell = Cell Green If not Red

    Morning Guys,

    For some reason I can not seem to make this work! I have done this before, but this morning its just not happening.

    I just want a simple conditional format. If the number in cell C15 equals the number is I15 then the cell turns green, if not the cell turns red.

    I have set it all up several times and it just wont change and I haven't got time to fiddle about with it. I need to check hundreds of rows, which would be easier and faster if they changed colour.

    Thanks

    Nathan.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Conditional Formatting - If Cell = Cell Green If not Red

    have you added a formula in a spare column and used
    =C15 = I15
    just to see if it is TRUE and so should change colour

    if you setup two rules
    which cell
    lets assume both

    in conditional formatting - set up two rules

    for Green

    =AND( $C15 <> "", $I15 <> "" , $C15 = $I15 )
    the two conditions using <> makes sure you are not checking blank cells

    and for red
    =AND( $C15 <> "", $I15 <> "" , $C15 <> $I15 )

    The $ fixed the column so you can select multiple columns to apply

    otherwise
    Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "Choose File" (top Left corner).
    Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-29-2016
    Location
    United Kingdom
    MS-Off Ver
    2013
    Posts
    6

    Re: Conditional Formatting - If Cell = Cell Green If not Red

    Thanks, I think I have it now. One of the cells is calculated from a complex formula to 15 decimal places, but its rounded it to 2 decimal places.

    Thanks.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Conditional Formatting - If Cell = Cell Green If not Red

    you are welcome

+ 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. Replies: 1
    Last Post: 01-06-2014, 04:31 AM
  2. [SOLVED] Conditional formatting - one cell green rest no colour
    By HHR in forum Excel General
    Replies: 15
    Last Post: 01-31-2013, 02:26 PM
  3. Replies: 6
    Last Post: 08-23-2012, 12:14 PM
  4. Replies: 3
    Last Post: 06-01-2012, 01:41 PM
  5. Replies: 0
    Last Post: 04-10-2012, 11:56 AM
  6. Help with conditional formatting:green pattern
    By vikkam in forum Excel General
    Replies: 5
    Last Post: 01-03-2007, 01:46 AM
  7. Conditional Formating-change the cell colour to green
    By stevekirk in forum Excel General
    Replies: 4
    Last Post: 10-20-2006, 02:52 AM
  8. Conditional formatting-green above a certain value
    By Brisbane Rob in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-05-2006, 03:11 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