+ Reply to Thread
Results 1 to 4 of 4

Excel Conditional Format Fails for cell>0

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Silicon Valley
    MS-Off Ver
    Office 365 for Mac
    Posts
    4

    Excel Conditional Format Fails for cell>0

    I need to format computed cells with value greater than zero. conditions I’ve tried fail
    E.G. Column E formatted with dark gray fill
    Conditional Format Rule =$E1>0
    Conditional Format Fill = none
    Example attached
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: Excel Conditional Format Fails for cell>0

    You do not have any rules that say

    =$E1>0

    I added one for column E and it seems to work fine (see row 56)
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-27-2012
    Location
    Silicon Valley
    MS-Off Ver
    Office 365 for Mac
    Posts
    4

    Re: Excel Conditional Format Fails for cell>0

    What's interesting is that you added a conditional format applicable to the entirety of column E, while I have been trying to make cells in E7 to E68 show no fill if the condition in my formula [=AND(OR($A7="H",$A7="T"),$B7<>0,$E7>0)]are met (some other cells will have non-zero values when used in the larger workbook).
    WhenI add $E7 to my formula for the range $E$7-$E$68, it doesn't work.
    If I add your suggestion covering all of Column E to my conditional format, it works, but I don't understand why.
    Note the conditional format in Column S, which mimics they original format in Column E does work.
    The only difference I can think of is that Column S is blank, while Column E is the result of a calculation with data from another sheet.
    Any ideas?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Excel Conditional Format Fails for cell>0

    I would avoid using full-column ranges, but could you explain - in words - exactly what your rules are, which columns they apply to, and which columns they are dependent on?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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: 12
    Last Post: 02-19-2018, 12:32 PM
  2. [SOLVED] Splitting date fails for a part of date column due to different cell format
    By Moriexcel in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-21-2014, 01:00 PM
  3. Excel 2010 or Excel 2003 : Conditional format for consecutive cell criteria
    By carol_sarah_759 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-04-2013, 09:04 PM
  4. Replies: 5
    Last Post: 06-30-2013, 06:54 PM
  5. [Excel 2007] Conditional format for particular cell
    By _DHT_ in forum Excel General
    Replies: 2
    Last Post: 03-31-2011, 09:58 AM
  6. In Excel, conditional format (font red) referencing another cell?
    By Christine Hemphill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2006, 02:04 PM
  7. Conditional Format Macro fails to set interior color - HELP!!!
    By bttman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2006, 09:25 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