Just as illustration, below is a simple VBA macro that does the formatting. It's up to you to decide if it's simple. Something similar could be put into the Worksheet_Change event sub.
This is a little more flexible than conditional formatting, because you can have different formats on each of row of the column your choosing the format from. (e.g. see column H in the screen cap's).
Here is a screen capture of the worksheet before running the macro ...
And here is a screen capture after running the macro ...
And here is the VBA code ...
Sub FormatTransfer()
Dim mySht As Worksheet
Dim myInRng As Range, myOutRng As Range, myFmtRng As Range
Dim myCell As Range
Set mySht = Worksheets("Sheet3")
Set myInRng = mySht.Range("E1", mySht.Range("E" & mySht.Rows.Count).End(xlUp))
Set myOutRng = myInRng.Offset(0, 2)
Set myFmtRng = mySht.Range(myInRng.Offset(0, 3), myInRng.Offset(0, 7))
For Each myCell In myInRng
If myCell.Value < 20# Then
myFmtRng(myCell.Row, 1).Copy
myOutRng(myCell.Row, 1).PasteSpecial xlPasteFormats
End If
If myCell.Value >= 20# And myCell.Value < 40# Then
myFmtRng(myCell.Row, 1).Copy
myOutRng(myCell.Row, 1).PasteSpecial xlPasteFormats
End If
If myCell.Value >= 40# And myCell.Value < 60# Then
myFmtRng(myCell.Row, 2).Copy
myOutRng(myCell.Row, 1).PasteSpecial xlPasteFormats
End If
If myCell.Value >= 60# And myCell.Value < 80# Then
myFmtRng(myCell.Row, 3).Copy
myOutRng(myCell.Row, 1).PasteSpecial xlPasteFormats
End If
If myCell.Value >= 80# And myCell.Value <= 100# Then
myFmtRng(myCell.Row, 4).Copy
myOutRng(myCell.Row, 1).PasteSpecial xlPasteFormats
End If
Next myCell
End Sub