Results 1 to 4 of 4

Thread: Dim the color of cells based on value

  1. #1
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0

    Dim the color of cells based on value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there a simple way to have the rows that have a balance of 0 appear dim when the sheet is loaded then if I enter a balance have it go back to "normal"?
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,225
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi Emanuel,

    You bet. You're looking for conditional formatting. Here's how you use it:

    - Select A2:Y43
    - Home --> Conditional Formatting --> New Rule
    - Use a formula to determine which cells to format (last option)
    - Formula: =$E2=0
    - Click Format --> Font --> Color --> Choose a light grey colour
    - Click OK --> OK

    That should do it for you.

    HTH,
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0
    Ken this works perfectly for me. Plus based on what I've read here on other posts I figured out what the formula does and was able to make a second one that will highlight any card that is at 90% or greater utilization.

    I have a few more tasks for my spreadsheet that I need help with but I'm going to make separate posts for them one at a time after I get each step working.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,225
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Cool stuff. That's a good way to go.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •