extending this formlar

K

kevatt

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
 
J

JE McGimpsey

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

valadating a data match 3
i need macro help 2
Lottery Spreadsheet - Find data in a table and color it... 1
still need help 1
Data Validation issue with two date entries Options 4
Excel Excel Help with variables 0
ANYTIME NEEDED MACRO FOR CONDITIONAL FORMATTING 11
check how many in a range from another range... 3

Top