Hello, I'm just wondering if anyone could possibly help me with some Excel code. So, I'm not sure if this is possible, however I want to make it so when there are 6+ numbers in a row, that are all below 1.5, highlight the 6+ numbers with a colour. I need this because I get massive amounts of data and need to see if there are 6+ numbers in a row, that are below 1.5 without manually looking through all the data that would take forever to look through thousands of numbers. Thank you for any responses. Here is an example of what I need highlighted when I put the data in Excel (This example has been done manually. I need this to be done automatically). Thanks. https://gyazo.com/4edea5e53805554b11439696835ac94e
Bookmarks