Color code measure for entire table

[jake4001]

Hi all, I have a table that looks like this, with many irrelevant columns between Team and ExceededGoalBy. I want to color code every row based on a calculation from the ExceededGoalBy column. How would I write a measure that I can use for Field Value in the conditional formatting with the following logic: if ExceededGoal <0, then use the color red. Else if >= 0 and <5, use color yellow, else if >= 5 then use green. Can somehow help me figure out how to write this DAX measure?

Team	RandomColumn1	RandomColumn2	ExceededGoalBy
1	a	hg	5
2	b	d	12
3	d	e	0
4	f	u	2
5	e	r	7

[parry2k]

@jake4001 this color measure:

Color Measure = 
VAR __Exceeded = SELECTEDVALUE ( Table[Exceeded Goal By] )
RETURN
SWITCH ( TRUE (),
    __Exceeded >= 5, "Green",
    __Exceeded >= 0, "Yellow",
    "Red"
)