Re: $$Excel-Macros$$ conditional formating / formula

You can also try ... *=VLOOKUP($A2,ColA,1,0)* ColA=='PAYMENT ADVICE SHEET'!A:A -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Nov 16, 2011 a

Re: $$Excel-Macros$$ conditional formating / formula

So one way would be to create a named range, for example, ColA, and use the formula ='PAYMENT ADVICE SHEET'!A:A to define it. Then in the Bill Sheet, by selecting the ranges in column A starting from A2, use the formula option in conditional format and give this formula.. =MATCH($A2,ColA,0) Sampl

$$Excel-Macros$$ conditional formating / formula

BILL SHEET BILL NO DATE MONTH AMT . 096 10-05-11 Apr-1115000 097 10-05-11 Apr-11 35000 099 10-05-11 Apr-1164,300 098 10-05-11 Apr-11 6 *PAYMENT ADVICE SHEET* BILL NO