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!
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
