Conditonal Format based on another Cells value.

[Double99]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Can someone please help me with a conditional format question.
<o></o>
<o></o>
I have a range of dates in Column A
Some numbers in Column B and..<o></o>
Two separate Dates in Column C. (Example Below)
<o></o>
<o></o>
I want to add a rule that says 'if a date is equal or greater than the date in C1, then italic the number in Column B.<o></o>
<o></o>
I also want to add another rule that says 'if a date is equal or less than the date in C2, then italic the number in Column B.

Note: I want to be able to change the dates in C1 and C2.

<o></o>
I know how to write the rules but because column B is not a date I don't know how to make the conditional format dependant on another cells value, therefore I don't know the formula to write
<o></o>
<o></o>
If someone could help me, that ould be great!
<o></o>
<o></o>
Thanks in advanced..<o></o>
<o></o>
Cris
<o></o>
<o></o>
EXAMPLE:
<o></o>
<o></o>
.......A ..............B ......C<o></o>
1 ....01/02/11 ....18 ....02/02/11<o></o>
2 ....02/02/11 ....18 ....05/02/11<o></o>
3 ....03/02/11 ....18<o></o>
4 ....04/02/11 ....18<o></o>
5 ....05/02/11 ....18<o></o>
6 ....06/02/11 ....18<o></o>
7 ....07/02/11 ....18<o></o>

 

[Richard Schollar]

Hi Cris

Select Column B and apply conditional formatting and change in the dialog to Formula Is and use the following formula:

=B1>=$C$1

and apply your italic format.

Add another condition and Formula Is and:

=B1<=$C$2

and apply your italic format. Then hit OK.

The above formulas assume you are starting in B1, if B2 make the first formula

=B2>=$C$1

etc

 

[Double99]

Many thanks for this…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
As a follow up question,
<o></o>
Do I have to apply each conditional format separately for each row?. Or is there a quicker way of doing this ‘ie Copy and Paste Format?’ so that it changes the B part automatically?
<o></o>
It just that I’ve done this for the whole year and don’t fancy putting in 365 conditional formats just to change the B part.
<o></o>
Note: Colum B’s figure has been generated from a formula.
<o></o>
EXAMPLE:<o></o>
……………………….Conditional Format would be..
<o></o>
line 1 – B1 ……=B1>=$C$1 ………=B1<=$C$2
<o></o>
line 2 – B2 ……=B2>=$C$1 ………=B2<=$C$2
<o></o>
line 3 – B3 ……=B3>=$C$1 ………=B3<=$C$2
<o></o>
line 4 – B4 ……=B4>=$C$1 ………=B4<=$C$2
<o></o>
line 5 – B5 ……=B5>=$C$1 ………=B5<=$C$2
<o></o>
line 6 – B6 ……=B6>=$C$1 ………=B6<=$C$2
<o></o>
line 7 – B7 ……=B7>=$C$1 ………=B7<=$C$2<o></o>

 

[Richard Schollar]

Select all your cells in column B (eg B2:B366) and apply the CF with the formula as before:

=B2>=$C$1

This will then be applied to each row in the selected range