Conditional Colour

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.

Screen Shots:

• Conditional Colour Menu
• Adding a new Range
• Picking a colour
• Organising and editing exisiting ranges
• Setting updating options

Documentation:

• Readme file
• Help file
• Version history

Program:

• Conditional Colour (Contains all the above document in the zip file)

Please email me if you wish to comment on this program, or to send in any bug reports or suggestions.

Navigation: Index