Skip to main content

Is it possible to use conditional formatting to compare two ROWS of data? I want it to compare my email open rate from the previous month to the current month. They'd use the same column of data but I want it to look at two different rows.


Help!


Thanks


Brooke

Hi Brooke


Thanks for posting on the community! You can compare your data set by simply selecting "Shape Data" for you Data Source. This option will then cause "Property" to pop-up. This will give you the option to choose the column of data you would like to compare. Then select the condition you would like. Please see the example screenshot and gif below. Take a look at the Conditional Formatting article in our Help Center to learn more about our Conditional Formatting feature.




Note: This will compare all of the rows with that column of data. Using the example above since January February and March all have data for the column Email Open Rate this conditional formatting Rule will apply to all three rows.


If you have any further questions please reach out again. Hope this helps!


Reply