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 don't have an unzipper yet then GET ONE. Try WinZip.
|Please email me if you wish to comment on this program, or to send in any bug reports or suggestions.|