Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for multiple conditions | Excel Discussion (Misc queries) | |||
Conditional Formating 4 conditions | Excel Discussion (Misc queries) | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |