Conditional Formatting

[ramsrahul]

I need a Macro for the following scenario.

If a value for Row 1 is Yes & Row 2 IS Yes, Row 3 should should display Green color

If a value for Row 1 is Yes & Row 2 IS No, Row 3 should should display Amber color

If a value for Row 1 is No & Row 2 IS No, Row 3 should should display Red color


Please help

 

[Smitty]

Welcome to the Board!

You can use the formula approach: =IF(AND(A1="Yes"),A2="Yes")

And so on...

HTH,

 

[ramsrahul]

Thanks a lot for your reply, But I need to have a color coding in Place (Green, Amber & Red) for different conditions. Kindly request you to throw some light on this.

 

[Smitty]

The formula I posted will manage your first rule (green), and is what you put in the Conditional Formatting criteria.

"And so on..." Referred to adding two more CF conditions after that, using the same formula, but adjusting the Yes/No's.

 

[lordguharoy]

sir can some body please guide me to format the row with specific color after after extracting the particular cell via vlookup(simultaneously)

 

[Smitty]

Welcome to the Board!

You'll need to be more specific. What range do you want to format? What's the criteria? I.E. If A1 > 10 then...

 

[lordguharoy]

sir actually i mean that if i apply v lookup to extract a data,can the whole row in the cell where the data is can be hilighted?

 

[Smitty]

Do you want to format the row that the VLOOKUP is in, or the row where the VLOOKUP found its match?

 

[lordguharoy]

the row where v lookup found the match not the criteria

 

[Smitty]

Select the VLOOKUP reference range, then assuming that the matching values are in column A, try:

=$A1=VLOOKUPRange