Hi There
If your conditions are not too complex, eg color cell blue if number = 618.5 or color cell green if text = "Final Count", you might like to try the following:
Right click your sheet tab, left click View Code and paste the following code in the white area:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Variant
Count = 0
Do Until Count = 12
If Target.Value = Range("A1").Offset(Count, 0).Value Then
x = Range("A1").Offset(Count, 0).Interior.ColorIndex
End If
Count = Count + 1
Loop
Target.FormatConditions.Delete
Target.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:=Target
Target.FormatConditions(1).Interior.ColorIndex = x
End Sub
Now use cells A1:A12 to hold your conditions, say they are the numbers 1 to 12.
Then colour each of those cells the colour you desire.
Now when you enter one of those numbers anywhere on the sheet the cell will assume the colour you have set. As the colour is in conditional formatting it will update if the value changes (eg as result of a formula).
Beware, however, that once you have set your colours in A1:A12 changing them will not automatically update your sheet.
You are not restricted to 12 colours/conditions - eg you could use A1:A55 but you would then need to change the line "Do Until Count = 12" to "Do Until Count = 55" .
Hope this is of some use to you.
regards
Derek