RE:conditionally-highlight-cells-in-one-column-based-on-text-values-in-another-column

I have a question regarding this thread.
http://www.excelforum.com/excel-prog...er-column.html
When the formula"

=AND(OR(INDIRECT(ADDRESS(ROW(),MATCH("Writing Tool",A$1:Z$1,0),4))="Pen",INDIRECT(ADDRESS(ROW(),MATCH("Writing Tool",A$1:Z$1,0),4))="Pencil"),COLUMN()=MATCH("Paper",$A$1:$Z$1,0))

is pasted into various columns in Doug's worksheet, it gives the correct true/false values but when inserted into conditional formatting, it does not apply any format. Does anyone know why?