Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a 120x120 matrix of five digit numbers like so:
52000 42222 43213 01016 52020 42200 43202 01000 52000 42202 43103 01016 52020 42200 43100 01000 52300 42000 43002 01010 52300 42020 43010 01010 53000 40222 41213 01216 53020 40200 41202 01200 53000 40232 41103 01006 ....and so forth. I want to highlight the cells that do not include a zero (the reverse works as well for me, highlighting the cells that do include a zero). I can't seem to make an if statement with find or search work out. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function question (probably easy) | Excel Discussion (Misc queries) | |||
Easy function question | Excel Discussion (Misc queries) | |||
Easy formula Question | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
easy question .... i think | Excel Discussion (Misc queries) |