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...
I'm trying to get some help with "what" type of formula i should be considering for the following challenge. I am trying to create an expense report template for Canadians that come to the US. There are daily currency rates as well as form of payment (CC, Debit, Cash) impacts to the calculation...
Feeling silly I cannot figure this out - since it appears pretty straight forward. That being said, I'm not above asking for help :)
I've uploaded the spreadsheet at:
https://docs.google.com/open?id=0B5W2MSEwwac5aEhYd1ZBSDJVQTQ
I am looking for the appropriate formula to calculate the...