Excel (upto 2003 version) only allows 3 conditions and sometimes you can put
4th conditon (default condition-the condition that exits by default).
In case you want to put more conditions then you'll have to use VBA as an
alternate or upgrade to Excel 2007.
On Thu, Apr 23, 2009 at 1:29 AM, Sam K
Hi
Why dont you try excel 2007 in that you can you use lol :)
On Tue, Apr 21, 2009 at 6:26 PM, Steve wrote:
>
> Hi,
>
> Can anyone tell me if there is a limit on the number of conditions you
> can place on a cell? I've got 5 and actually need 6, however, when I
> select apply, the last conditi
Sorry, I had the 5 formats set to give me a particular color if a
certain cell
was blank. After the blank rows, everything turned that color because
the whole
rows were blank, which isn't what I was after. So, my first attempt
was to have
a conditon to say if the first cell in a row was blank, to
Steve --
Excel 2003 is limited to 3 conditions
-- since you are talking about 5 or 6 conditions, you must be working
in Excel 2007, without these same limitations
Probably, your 6th rule is present - but, the Conditional Formatting
Rules Manager dialog is only large enough to display 5 rules
