Cumulating formating conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top