+ Reply to Thread
Results 1 to 2 of 2

Excel 2016 Conditional Formatting

  1. #1
    Registered User
    Join Date
    09-06-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    69

    Excel 2016 Conditional Formatting

    Hi,

    Can someone help me with the below? I have a license for Office 2016. I am trying to create a spreadsheet which does the following.

    1) Make G and H column = A and B column (So, whatever is typed in A and B column appears automatically in G and H column)

    2) If I column is not the same as C column - then colour the cell K green. If not highlight the cell red and display text 'missing part' in column K.

    Thank you for any tips you may have.



    Excel Hlep.PNG

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Excel 2016 Conditional Formatting

    in G1
    =IF(A1<>0,A1,"")
    in H1
    =IF(B1<>0,B1,"")

    in K1
    =IF(I1<>C1,"Missing Part","")

    Select K1

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =(I1=C1)
    format as green

    =(I1<>C1)
    format as red

    Use Format painter (paintbrush icon) to copy to other cells
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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: 20
    Last Post: 10-19-2016, 06:05 AM
  2. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  3. Conditional formatting with udf issues with Office 2016 / Office 365
    By andikeep2580 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2016, 10:58 AM
  4. Conditional Formatting in Excel 2016
    By Mansfieldexcel in forum Excel General
    Replies: 2
    Last Post: 03-21-2016, 01:56 PM
  5. [SOLVED] Excel 2016: Conditional Formatting to highlight weekends
    By ClareLou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2016, 01:25 PM
  6. Replies: 9
    Last Post: 12-17-2015, 10:44 AM
  7. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 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