i wonder if there is a way to go over an excel sheet and find data by the header name and not by its index location.
for example: i want to get the data that is located under FName header on row number 4 (FName, 4).
or it can't be done and i must use index (1,4)?
Ho and in addition how can i create a formula in excel 2007 that will paint cells by its text. for example: if the text inside the cell is PASS it will be automatically changes to green,etc