I know that he pointed me towards a forum once where he'd got a nice little series of Excel tips, and this was one of them - trouble is, I can't remember where it was! I like the "workaround" in the link you gave, but I'd like to use VBA on this one if possible
Presumably your code that does text colours has something like
thecell.Font.ColorIndex = vbRed
or something like that. To do the background you simply change it to be:
thecell.Interior.ColorIndex = vbRed
i.e. change .Font to be .Interior and you are there.
Generally with VBA once you have some code you can often google to find what you need to do with it once you are comfortable. E.g. in your situation with the above all I did was google "excel vba background colour" or "excel vba font colour" to compare the different syntax for the two.
Hope this helps, let me know.
This thread is now locked and can not be replied to.