+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting not working

  1. #1
    Registered User
    Join Date
    08-11-2013
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    16

    Conditional formatting not working

    Hi

    I am trying to put conditional formatting to some cells. I attach a file.

    What I want the conditional formatting to do is:

    if A1>B1, Change C1 to Green font
    if A1<B1, Change C1 to Red font
    if A2>B2, Change C1 to Green font
    if A2<B2, Change C1 to Red font

    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Conditional formatting not working

    What is the priority here? if A1>B1 and A2<B2 does C1 have a red or green font?

  3. #3
    Registered User
    Join Date
    08-11-2013
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Conditional formatting not working

    if A2<B2, change C2 to red font. Sorry, typing error for this formula

  4. #4
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Conditional formatting not working

    Take out the if's. =A1<B1 is enough.

+ 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 VBA not working
    By ArtySin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-12-2013, 07:41 PM
  2. Conditional Formatting not Working
    By braydon16 in forum Excel General
    Replies: 7
    Last Post: 05-23-2012, 02:41 PM
  3. Conditional Formatting Not Working
    By mycon73 in forum Excel General
    Replies: 14
    Last Post: 07-16-2011, 01:39 PM
  4. Replies: 0
    Last Post: 01-20-2009, 05:19 PM
  5. Several Conditional Formatting only working on some
    By joblinger in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2009, 05:17 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