| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find all cells NOT containing "100%" -no loop solution needed
Hi,
I have several areas but all cells also are one named range "ALL_PERCENT_CL", if that helps. The cells have format percent and should be 100% as standard, but user can change this to any perecentage, like 30% instead. It could also be a formula "=2*20%" of course. Or "0" or "". (If needed, I could set some conditional formatting on the cells - they could even contain letters!.) -- How can I fastest (9000 cells in total) find the cells that are not 100%? I have tested some "non-loops" solutions like Find-next and GoTo, but couldn't make it out. Any knowledge in this to share? Kind regards tskogstrom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| fomula needed to find the "new" time, for example if | Excel Discussion (Misc queries) | |||
Threaded Mode
