It was written to address a lack of conditional formatting in Excel.
EditBy: Conditional Colour is an Excel Add-In which allows the conditional formatting of the text colour of cells dependant on their contents. It allows for many ranges to be set up with different conditions each. Up to two conditions and a Default are allowed for each range, although more conditions can be made by applying conditional colour twice to the same range, with different conditions. Note that this is designed for Excel 5, and is obsolete (although it will still work) for version 7.

This program was written to address a lack of conditional formatting in Excel. It seems that it is not possible for a function to change the formatting of its cell, so I wrote a set of macros which will allow this sort of effect to be created. Using this program it is possible to set up ranges of cells to apply conditional formatting to, which when updated will have their text colour modified according to a set of rules. It allows for many ranges to be set up with different conditions each. Up to two conditions and a default are allowed for each range, although more conditions can be made by applying conditional colour twice to the same range, with different conditions. Oh yes, and the files are zipped, so if you dont have an unzipper yet then GET ONE. Try WinZip. you can free download Conditional Colour 2.3 now.