Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extending a range | Excel Discussion (Misc queries) | |||
Extending a macro | Excel Discussion (Misc queries) | |||
extending columns | New Users to Excel | |||
Extending VLOOKUP | Excel Worksheet Functions | |||
Extending Row() | Excel Worksheet Functions |