Forum Discussion

Jackson1's avatar
Jackson1
Copper Contributor
Nov 16, 2022
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 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 

  • Jackson1 

    =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

  • Jackson1 

    =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.

     

    • Jackson1's avatar
      Jackson1
      Copper Contributor
      Amazing, that makes sense. Thank you!!

Resources