Hi

I have 2 areas where I need help

Help-1:
I need help in "copy" or "move" (but append) a row from a "data" tab if it meets a certain condition into a "new" tab.
I familiar with formula usage but not VBA

Eg:
If tabname=data has rows such as: "^" is indicative of new column for visual only
Index^firstname^lastname^dob^country
1^fn^ln^120811^usa
2^fn2^ln2^081211^canada
....
I'm looking to copy/append indexed row=2 if "firstname=fn2" into a new column, say "output" and output tab should look like
3^fn4^ln3^110811^mexico
2^fn2^ln2^081211^canada

Help-2:
I have frequently used conditional formatting on the cell value itself. However, conditional formatting is not working if the condition being tested is another cell. Eg: Let's say A1="value"; I want C4="test A1=value and if true" and turn GREEN or turn RED if not true. My conditional equation works on A1, itself - but not if I want C4 to format based on A1.

Thx
Rajiv
[email protected]