Cumulating formating conditions

Hello...
I have a litle question for you guys...I'm using conditional formatting for
a little time and I am stuck with a problem: I want to use 2 conditional
formating for a range. The two conditional formatting are:
CF1: ($J3<TODAY(),$J3>TODAY()-7), format:BOLD
CF2: ($B3<>Z10), format patern: bleu color
THE PROBLEM is that I can't cumulate the both conditions when this is
necesary.

Please can you help me...I looked all over the disscusions here and I didn't
find anything...

thanks
--
Dragos

Dragos,

Try making the first conditions:
=AND($J3<TODAY(),$J3>TODAY()-7, $B3<>Z10)

with the format set to both Blue Pattern and Bold text

and then the next two conditions with one and then the other condition and
format

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"Dragos" <[email protected]> wrote in message
news:[email protected]...
> Hello...
> I have a litle question for you guys...I'm using conditional formatting
> for
> a little time and I am stuck with a problem: I want to use 2 conditional
> formating for a range. The two conditional formatting are:
> CF1: ($J3<TODAY(),$J3>TODAY()-7), format:BOLD
> CF2:, format patern: bleu color
> THE PROBLEM is that I can't cumulate the both conditions when this is
> necesary.
>
> Please can you help me...I looked all over the disscusions here and I
> didn't
> find anything...
>
> thanks
> --
> Dragos

Thank You very much! It worked beautifuly!
--
Dragos


"Sandy Mann" wrote:

> Dragos,
>
> Try making the first conditions:
> =AND($J3<TODAY(),$J3>TODAY()-7, $B3<>Z10)
>
> with the format set to both Blue Pattern and Bold text
>
> and then the next two conditions with one and then the other condition and
> format
>
> --
> HTH
>
> Sandy
> [email protected]
> Replace@mailinator with @tiscali.co.uk
>
>
> "Dragos" <[email protected]> wrote in message
> news:[email protected]...
> > Hello...
> > I have a litle question for you guys...I'm using conditional formatting
> > for
> > a little time and I am stuck with a problem: I want to use 2 conditional
> > formating for a range. The two conditional formatting are:
> > CF1: ($J3<TODAY(),$J3>TODAY()-7), format:BOLD
> > CF2:, format patern: bleu color
> > THE PROBLEM is that I can't cumulate the both conditions when this is
> > necesary.
> >
> > Please can you help me...I looked all over the disscusions here and I
> > didn't
> > find anything...
> >
> > thanks
> > --
> > Dragos
>
>
>