Pivot table heat map

Give the job state a numeric value and then take the Max of that as the data value.
You can then apply conditional formatting

Here's what I did:

1) Add another column in the table that turns the "State of Job" into a numerical quantity, call it "State Code."
I did that on a 1-5 number range, with "Not Started" as 1 and "Compete" as 5; the input-to-number conversion was handled automatically by INDEX(MATCH) in a seperate table, although since that's almost a Likert scale, you could decided to just have people input the number itself (or put in "% complete" as an input, etc).

2) Then, set the PT's value field to the average of the State Code. Well, since the Project by Due Date axis means there should be one entry in each field, then you could do sum instead.

3) Apply a conditional formatting rule to the PT field. I just used one rule, "Graded Color Scale" that goes from red at low to green at high, although if you wanted more specificity you could apply three different rules, or use those red/yellow/green traffic light icons instead.

Well, in general:
1) Process the appropriate input into a number
2) Make that number the "value" setting
3) Apply conditional formatting to the area of the pivot table

I would advise doing that.


EDIT:
...And, now I see that I got beaten past the post by the esteemed Mr. Pope. Like, we both did the exact same thing, basically.