+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting if G9>F9 but not if F9=0

  1. #1
    Forum Contributor
    Join Date
    11-20-2008
    Location
    UK
    Posts
    132

    Conditional Formatting if G9>F9 but not if F9=0

    As per the title really.

    I want some conditional formatting to change the font colour of text in another cell if G9 is greater than F9 but not to apply it if F9=0. I can't seem to get If statements to work in Conditional formatting. Either that or I'm doing it wrong which is quite possible

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Conditional Formatting if G9>F9 but not if F9=0

    Try use =(G9>F9)*(F9<>0)

  3. #3
    Forum Contributor
    Join Date
    11-20-2008
    Location
    UK
    Posts
    132

    Re: Conditional Formatting if G9>F9 but not if F9=0

    Quote Originally Posted by zbor View Post
    Try use =(G9>F9)*(F9<>0)
    Ahh yes of course! Simple really. Thanks again!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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