I was wondering if there is any easy way to make an excel sheet Highlight data for the following rules. I need the values of the rows inside of the columns to be equal to each other for two columns (ex: and(a1=a2,b1=b2)). And also be within a range of the last 6 consecutive months. I have basic functionality as I can do an and statement inside of an if statement but I need the dates as well. Thanks!
I am not quite sure if I have understood your question correctly. If I am correct, the formula should give the answer TRUE if your conditions apply. Try it out.
