Re: $$Excel-Macros$$ Formulae in Conditional Formatting

2014-06-18 Thread Vaibhav Joshi
hey share sample file so that solution given matches your expectation. Thanks On Wed, Jun 18, 2014 at 5:06 PM, Nicci Deaves wrote: > I want to match names in a column on one sheet to names in a column in > another sheet in the same workbook and conditionally format the cell to > show whether

$$Excel-Macros$$ Formulae in Conditional Formatting

2014-06-18 Thread Nicci Deaves
I want to match names in a column on one sheet to names in a column in another sheet in the same workbook and conditionally format the cell to show whether there is a match or not, I know I need to use ISNA and VLOOKUP but can't work out the formula! Keep getting formula error message. Can an