+ Reply to Thread
Results 1 to 3 of 3

conditional formatting with IF function issue

  1. #1
    Registered User
    Join Date
    10-16-2018
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 365 MSO
    Posts
    2

    Question conditional formatting with IF function issue

    Hi all,
    I'm having trouble with the greater than and less than function using the value of the IF function. I've attached a file for example.

    The IF function is simple if Y = 5%, if N = 10% then i want my total % in column K to shade red is less than that value or shade green if greater than it. It seems super simple so i'm not sure where I've gone wrong? please help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: conditional formatting with IF function issue

    Remove the double quotes from 5% and 10% in the formula.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-16-2018
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 365 MSO
    Posts
    2

    Cool Re: conditional formatting with IF function issue

    I knew it would be something simple!! Thank you so much!

+ 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] Conditional Formatting Issue
    By skyhawk98795 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-01-2016, 09:56 PM
  2. [SOLVED] Conditional formatting issue
    By Hawkmoth1 in forum Excel General
    Replies: 8
    Last Post: 03-23-2015, 05:41 PM
  3. Custom formatting issue using conditional formatting
    By wrongway15 in forum Excel General
    Replies: 2
    Last Post: 07-13-2014, 03:18 PM
  4. Conditional Formatting issue
    By roenajoyave in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-12-2013, 12:00 PM
  5. Conditional Formatting Issue
    By bumperbg in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 04:19 AM
  6. Conditional Formatting Issue
    By netcat17 in forum Excel General
    Replies: 6
    Last Post: 04-05-2010, 07:57 PM
  7. conditional formatting issue
    By associates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2006, 03:45 AM

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