extending this formlar
 

is there a way that i can enter a short formular into a cell and ask it
to match data that would have been manully entered

iE: cells w19 to w130 has postcodes in it e11 is where the data is
manuly entered a data match would flag a match in some way or visa
versa a mismatch could flag using formlar (red)=a1=d1 is there a way
that i can add to this formlar to search w19 to w130
thanx


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=519116

extending this formlar
 

You could use a formula in Conditional Formatting.

Select E11. Choose Format/Conditional Formatting... Configure the
dropdowns and textboxes to enter the formula

CF1: Formula is =COUNTIF($W$19:$W$130,E11)
Format1: <patterns/<choose a color



In article ,
kevatt wrote:

is there a way that i can enter a short formular into a cell and ask it
to match data that would have been manully entered

iE: cells w19 to w130 has postcodes in it e11 is where the data is
manuly entered a data match would flag a match in some way or visa
versa a mismatch could flag using formlar (red)=a1=d1 is there a way
that i can add to this formlar to search w19 to w130
thanx