Conditional Format - Two Criteria and Different Tabs

[amac3434]

Hi- Looking for some help from you smart folks.

I have a spreadsheet that have two tabs. I want to set a conditional Format (color) on Tab 2 when two conditions are met on Tab 1.

What I want is to say:
If in Sheet 1 - The Phase is "Ready to Test" and the Type is not "TW" then turn corresponding Client Name on Sheet 2 to Yellow

Sheet 1:
Type: Phase: Client Name:
DP Ready To Test Acme
SP In Testing Bubba's
TW Complete Smith's

Sheet 2:
Client Name:
Acme
Bubba's
Smith's

I can't seem to crack this. Any guidance would be appreciated.
Audrey

 

[NARAYANK991]

Hi ,

Can you please upload your workbook with the data in it ?

Narayan

 

[GraH - Guido]

you can use this I suppose.
AND(INDEX(Sheet1!$A$2:$A$4,MATCH(Sheet2!$A2,Sheet1!$C$2:$C$4;0))<>"TW",INDEX(Sheet1!$B$2:$B$4,MATCH(Sheet2!$A2,Sheet1!$C$2:$C$4;0))="Ready to Test")