Forum Discussion
Solved
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 givi...
=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.
=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.
Amazing, that makes sense. Thank you!!