Forum Discussion

Austin535's avatar
Austin535
Copper Contributor
Jul 25, 2022

Excel Formmating

Hello all, 

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!

excel
Formulas and Functions

1 Reply

Sort By
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Jul 25, 2022

    Hi Austin535,

    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.

    =AND(AND(A1=A2,B1=B2),IF(A2>B2,B2>=EEDATE(A2,-6),A2>=EEDATE(B2,-6)))

     

Resources