conditional formatting 2 cells

[Guest]

in Excel 2002 it states that you can use up to 3 different conditions for a
conditional format, but it will only use the first format that is applied
when the condition is true. Am I reading this wrong? What good are the second
and third conditions if it will only use the first format? Assuming I don't
get it, I would like to apply 2 different formats in the same cell, depending
upon the entries in 2 different cells. Cell A1 = 10, Cell B1 = 15,
conditional format is if C1 is greater than A1 apply yellow, if C1 is greater
than B1, apply bold in addition to yellow. Can this be done without VB code?

Thanks, smart people!

 

[Guest]

Set 1st condition as "Value is" > $B$1 and colour yellow, font bold
set 2nd condition as "Value is" > $A$1 and colour yellow

HTH

 

[SteveG]

Assuming the 10 and 15 are constants. Since B1 is greater than A1 the
if C1 is greater than B1, C1 will always be greater than A1 so in th
first condition, select the Formula is option and enter this:

=C1>B1

Format for Bold and Yellow

Second condition:

=C1>A1

Format for yellow only.



HTH

Stev

 

[Guest]

Thank you very much, that worked exactly!

 

[SteveG]

You're welcome.

Thanks for the feedback.

Stev

 

[Guest]

Excellent, thank you!

Set 1st condition as "Value is" > $B$1 and colour yellow, font bold
set 2nd condition as "Value is" > $A$1 and colour yellow

HTH