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 a
CF1: ($J3<TODAY(),$J3TODAY()-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(),$J3TODAY()-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

Replace@mailinator with @tiscali.co.uk


"Dragos" wrote in message
...
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 a
CF1: ($J3<TODAY(),$J3TODAY()-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(),$J3TODAY()-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

Replace@mailinator with @tiscali.co.uk


"Dragos" wrote in message
...
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 a
CF1: ($J3<TODAY(),$J3TODAY()-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