• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. H

    Conditional Formatting

    I am using a list on 1 sheet for a drop down list on another. I have added colour to the list. (Each item is a different colour) is there a way so that when you use the drop down option that picks from the list the colours from the list show on your selection. (I have 24 choices on the list). I...
  2. H

    Displaying a large amount of text in one cell by hovering.

    Good morning, I use a workbook that basically has a few cells with just a few words and some that contain a lot of text. When we use this for presenting we sometimes need to see the full content of the cell. Is there a quick way of displaying this? Ideally I would just want to hover over the...
  3. H

    Highlight a row if cells meet certain conditions

    Good evening, new post for me. I am trying to use conditional formatting to highlight a row if certain conditions are met. 3 x options Y, N or NA. If all 3 are Y, Y, Y I want the row highlight green If I have Y, Y, NA again I want this green (NA should be read as Y) If any one shows N the row...
  4. H

    Excel count and conditional formating

    I am try to create a formula that will count certain criteria. This is my first post so will try my best to explain what I am trying to achieve. I have one figure x (total leave), y (total booked), z (total remaining). These are in separtate cells. New leave is issued 1 Apr, you must have 15...
Back
Top