Microsoft Office Tutorials and References
In Depth Information
Using More Than Three Conditional Formats
Similar to the SUMIF worksheet function, the third argument is
optional. See the file for examples.
Note: These functions do not count colors if they have been applied using
conditional formatting. For those, use the condition behind the conditional
format to do the COUNT/SUM.
Also, these functions do not update when you change the format of a cell, for
that, you must update the worksheet/workbook by pressing F9 or Ctrl+Alt+F9
to force a full recalculation.
Using More Than Three Conditional Formats
With this procedure, you can overcome the limitation of using only three
conditional formats.
Example file:
Scenario: Users often want more than three conditional
formats, but the Format Æ Conditional Formatting option only
provides for three. Using VBA, however, allows you to overcome
this limitation and to create as many conditions as necessary.
For example, you may be evaluating credit scores, coloring
them in bands of 50 points, going from bright red to bright
blue, to give an indicator of how reliable a potential customer
may be. Now you can use as many colors as you like.
This example assumes the following different sales levels and provides
conditional formatting, as follows:
$0 – $15,000
= dark blue
$15,001 – $25,000 = blue
$25,001 – $35,000 = light blue
$35,001 – $50,000 = light red
$50,001 – $75,000 = red
$75,001 and more = dark red
Search JabSto ::

Custom Search