• 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. A

    Conditional Formatting in a Range

    Worked!! Thank you !!
  2. A

    Conditional Formatting in a Range

    I did as you and p45cal suggested and still did not work. I'm going crazy!
  3. A

    Conditional Formatting in a Range

    Well, it's working the way the formula is written.
  4. A

    Conditional Formatting in a Range

    Thank you Decio! Much better your way! You both helped a lot, but... every time I work this spreadsheet, something new happens. Now I'm having a problem with the data validation. Since I cant repeat a number in the same line I created a Data Validation that doesn't allow this and immediately...
  5. A

    Conditional Formatting in a Range

    That is perfect! Thanks a lot! Thanks, above all, for your patience!
  6. A

    Conditional Formatting in a Range

    Attached is the file. Each individual line can't repeat one number already in the same line, but other line can repeat the number in another line and even repeat the entire line. What I need now is to check in the entire range (now it is from B5 to P34) what are the most commons numbers...
  7. A

    Conditional Formatting in a Range

    Thank you, that worked fine! Another doubt, I also need to find the 1st, 2nd, 3rd...and 15th more occorring number in the range. Could you help please? Thanks a lot!
  8. A

    Conditional Formatting in a Range

    I have numbers in a range from B5 to P35 which I need to color them everytime they match to the ones in B2 to P2. Each number in the range of B5 to P35 need be colored if it matches one number in the line B2 to P2. Help, please.
Back
Top