Go to Bob Phillips' site and download the CFPlus add-in which allows up to 30
conditions.
http://www.xldynamic.com/source/xld.....Download.html
Gord Dibben MS Excel MVP
On Thu, 14 Sep 2006 18:32:01 -0700, Greg L
wrote:
Thank you for the help.
"JLatham" wrote:
The only way I've found around the 3-condition limit is to write a custom VBA
macro to detect when a change in the cell(s) takes place, evaluate the new
value and set the format accordingly. You can have virtually unlimited
conditions using this method.
"Greg L" wrote:
I'm trying to use conditional formatting in Excel but am limited to only 3.
Has anyone found a way around this?? I have 4 letters with different
background colors that I'm using and rather than copy and pasting I'm trying
to use a cell pull down but end up having to manually copy and paste one due
to the fact I'm using a default clear cell as a starting point.
Thanks, Greg
Gord Dibben MS Excel MVP