Reply to thread

Message: [QUOTE="Bernie Deitrick, post: 6370208"] This was your example: T155 R95 Sec30: NW4 How do I go from that to: Perhaps just the NW4? Anyway, try this: Enter your tax map id T155 R95 Sec30: NW4 in cell AA1. Then, create a table in A101:X124 with the descriptors NW4, etc. entered in each. Then for cells A1:X24 (your township map), format them with a green fill, and then use something like this formula in Format / Conditional Formatting.... with the Formula Is option: =COUNTIF($AA$1, "*" & A101 & "*")>0 and set your CF fill to some color, say red. HTH, Bernie MS Excel MVP [/QUOTE]