| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coloring a cell if it does not match on another worksheet
Hi Tom,
In my opinion, there is no need for a macro ... With conditional formatting, use Formula Is =ISNA(Match(yourCell,yourRangeName,0)) and pick whatever format differentiator you want ... Do not forget to Insert Name Define yourRange, since all elements are not located in the same worksheet. HTH Cheers Carim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Coloring | Excel Discussion (Misc queries) | |||
| Cell coloring | Excel Discussion (Misc queries) | |||
| Fill coloring for Past Dates in a worksheet | Excel Worksheet Functions | |||
| Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
| match cell from one worksheet to data in another | Setting up and Configuration of Excel | |||
Threaded Mode
