+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting a cell which is showing a %

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Conditional Formatting a cell which is showing a %

    Hi everyone,

    I am currently having a problem with conditional formatting a specific cell. Im not sure if this has anything to do with it, but there is a formula in the cell which is =Calculations!J5 - that is drawing a % from another worksheet in the spredsheet. The current conditional format I have on the cell is:

    Condition 1 - Cell Value Is - Equal to - ="""""" I have formatted the cell so there is no colour.

    Condition 2 - Cell Value Is - Greater than or equal to - 0.85 I have formatted the cell so there is green colour.

    Condition 3 - Cell Value Is - Less than - 0.85 I have formatted the cell so there is red colour.

    When there is a % of 85 or more the cell does turn green and when there is a % lower than 85 it turns red but if the cell is empty it will go green. Any help on how i can get this cell to just have no colour?

    Many thanks!!!!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You have to many quotes in the 1st condition...

    use only 2 double quotes...

    i.e. =""
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220
    many thanks

+ 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: cell contains text?
    By lkb3 in forum Excel General
    Replies: 2
    Last Post: 06-26-2008, 01:54 PM
  2. Conditional Formatting based on value of another cell
    By pickledmuffin in forum Excel General
    Replies: 3
    Last Post: 05-19-2008, 06:40 PM
  3. Conditional Formatting on Every Cell in Every Row
    By ryan_mufc11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2008, 10:20 AM
  4. Conditional formatting referencing another cell
    By tryer in forum Excel General
    Replies: 1
    Last Post: 06-16-2007, 03:26 AM
  5. Replies: 6
    Last Post: 05-17-2007, 07:08 AM

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