Measure for above and below average with conditional formating

Hi:

Please see link for the figures (they are in either "Result Table" or Sum Table".) I hope this is what you are looking for. My average is higher than yours $2.85 v $2.24...

https://drive.google.com/file/d/14fcOeKrRrKhdClu7gIcyra7F4Rdx4d9W/view?usp=sharing 

hi sriramk 

1. IF ( MAX ( Table1[Revenue/Cost] ) >= [Average Rev/Cost] ), "Above Avg", "Below Avg" )

2. MAX ( Table1[Revenue/Cost] ) >= [Average Rev/Cost] )  
then use the measure in the conditional formatting >= 1 for green and 0 for red

3. DIVIDE ( MAX ( Table1[Revenue/Cost] ) - [Average Rev/Cost] , [Average Rev/Cost] )

4.  Please clarify further