I have a excel formula (mentioned below) which correctly returns true. But when I used the same formula in conditional format, I am not able to get the conditional format. Please help.
=AND(FIND("MyText",INDIRECT(ADDRESS(1,COLUMN()))),INDIRECT(ADDRESS(ROW()+2,COLUMN()))=1)
If the first cell of the column is "My-text" and the value is 1 (in row +2, same column) the formula correctly returns true. If I used it in a conditional format to paint a fore-ground color it is not working. I also tried search and searchb. But didnt work. The format of the cell (row() +2, column) that might have value 1 is "General". The conditional formula works in excel 2003 but not in excel 2010
Refer the formula in A3. The cell with the conditional format formula C3.
=AND(FIND("MyText",INDIRECT(ADDRESS(1,COLUMN()))),INDIRECT(ADDRESS(ROW()+2,COLUMN()))=1)
If the first cell of the column is "My-text" and the value is 1 (in row +2, same column) the formula correctly returns true. If I used it in a conditional format to paint a fore-ground color it is not working. I also tried search and searchb. But didnt work. The format of the cell (row() +2, column) that might have value 1 is "General". The conditional formula works in excel 2003 but not in excel 2010
Refer the formula in A3. The cell with the conditional format formula C3.