On Tue, 6 Dec 2005 10:23:31 -0600, sabunabu
wrote:


Is there any way to have 4 conditions? I only see the option for 3.

TIA,

sabu

Well, you can have your baseline format + 3 conditional formats so that is kind
of like having four.

If that won't do it for you, there have been multiple VBA solutions posted in
this and related news groups. Just do a Google search for conditional
formatting, and you should find plenty of solutions.


--ron