I have been given an excel document which colors a certain column based on a conditional format. If the cell's value is within the top 30%, it's colored Green, within the bottom 30% is Red, otherwise Yellow.



I need to export this color value, so I've been trying to create a formula to represent the value as either 'R', 'Y' or 'G'. I was able to get one of the other columns working (not the same formula), which was based on the cell's value:

= IF(I:I>0.45,"G",IF(I:I< 0.35,"R","Y"))

but for this column (J:J - formatted as currency) I don't know how to determine if the cell's value is within the upper or lower 30% for that column. Can someone help me with the proper formula to do this?

= IF(J:J...??,"G",IF(J:J...??,"R","Y"))