I am trying to conditionally format using AND() to reference if there is a value in the top line of a table and the title in the right most column for each cell in the table, the formula I am using works when i paste it into cells (i get the correct TRUE or FALSE for each cell in the sheet) but is not working as a format formula, I dont get an error but the shading does not happen. any idea's why?
the formula:
=AND(OFFSET($A$1,0,(COLUMN()-1),1,1)<>"",INDIRECT("a"&ROW())="Item1")
the formula:
=AND(OFFSET($A$1,0,(COLUMN()-1),1,1)<>"",INDIRECT("a"&ROW())="Item1")