Heatmap with Text

[smms1]

I was wondering if I could do a heatmap but with some texts in each cell. I know how to make numeric values invisible but not how to add text. Much appreciated.

 

[Snakehips]

@smms1 Welcome.
The lack of response on this would reinforce my thoughts that what I think you want to do is not straightforward.
So maybe the silly example below, using a dat range and a text range, will give some food for thought?
I reckon you will need both a numeric data range (can be remote or hidden) and a related 'text' range.
I've used LOOKUP to get related text. Then depending upon how you envisage data will be edited you will need Change Event vba like one or other of the below.

Book1
	D	E	F	G	H	I	J	K	L
7									Lookup
8	Highest	LowMid			4	2		1	Lowest
9	Lowest	Lowest			1	1		2	LowMid
10	Highest	LowMid			4	2		3	HighMid
11	HighMid	Highest			3	4		4	Highest
Sheet1

Cell Formulas
Range	Formula
D8:E11	D8	=LOOKUP(H8,$K$8:$L$11)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H8:I11	Other Type	Color scale		NO

Private Sub vvWorksheet_Change(ByVal Target As Range)
'If ONLY one root cell is to be updated at any given time

If Intersect(Target, Range("H8:I13")) Is Nothing Then Exit Sub
If Target.Cells.Count > 1 Then Exit Sub

Target.Offset(0, -4).Interior.Color = Target.DisplayFormat.Interior.Color

End Sub

Or

Private Sub Worksheet_Change(ByVal Target As Range)
'If more than one root cell might be updated eg paste Values to whole range

If Intersect(Target, Range("H8:I13")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Application.ScreenUpdating = False
For Each Cell In Range("H8:I11").Cells
    Cell.Offset(0, -4).Interior.Color = Cell.DisplayFormat.Interior.Color
Next
Application.ScreenUpdating = True
Application.EnableEvents = True

End Sub