Forum Discussion
Jackson1
Nov 16, 2022Copper Contributor
Return text based on cell color or conditional formatting
Hello, I work for a non-profit and am updating a donor register. We have calculated % of difference in giving activity between 2021 vs 2022 and now want to categorize which donors based on their giving frequency.
I conditionally formatted the percentages by green, yellow and red. I would like to have another column that returns text based on what the % of difference column values. Thank you
=IF(B2<30,"high",IF(B2<60,"higher",IF(B2<100,"highest","")))You can apply the rules for conditional formatting in an IF statement as shown in the example.
2 Replies
- OliverScheurichGold Contributor
=IF(B2<30,"high",IF(B2<60,"higher",IF(B2<100,"highest","")))You can apply the rules for conditional formatting in an IF statement as shown in the example.
- Jackson1Copper ContributorAmazing, that makes sense. Thank you!!