conditions highlight row

[Nozama]

Ok one more time

if B2=Final and C2=Active A2 thru D2 are red, sorry this may be really easy but I don't know excel at all.

Please note that if any of the conditions aren't met the row must not be highlighted.

[Jay Petrulis]

On 2002-03-24 08:46, Nozama wrote:
Ok one more time

if B2=Final and C2=Active A2 thru D2 are red, sorry this may be really easy but I don't know excel at all.

Please note that if any of the conditions aren't met the row must not be highlighted.

Hi,

1. Select A2:D2
2. Format>Conditional Formatting
3. Condition 1>Formula Is
4. =AND($B$2="Final",$C$2="Active")
5. Format to suit

This should do the trick.

Bye,
Jay

[Aladin Akyurek]

On 2002-03-24 08:46, Nozama wrote:
Ok one more time

if B2=Final and C2=Active A2 thru D2 are red, sorry this may be really easy but I don't know excel at all.

Please note that if any of the conditions aren't met the row must not be highlighted.

If only A2:D2 is of interest, use the formula

=AND($B$2="final",$C$2="active")

for Condition 1. Have a look at my reply to your earlier post for the full procedure.