Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
marking cells that do not have a formula?
I have a worksheet that the formula's are overriden freeequently (thats the way its supposed to be). Is there a way to mark the cells that now contain numbers and no formula? I have a macro that colors cells that contain formulas. I need the opposite too. Can I modify it? Sub markformula() Cells.SpecialCells(xlCellTypeFormulas).Interior.Co lorIndex = 35 End Sub TIA Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marking cells | Excel Discussion (Misc queries) | |||
Marking data sets with non-blank cells | Excel Discussion (Misc queries) | |||
check marking and highlighting specific cells | Excel Discussion (Misc queries) | |||
Marking unlocked cells in active worksheet | Excel Discussion (Misc queries) | |||
Speed of marking cells | Excel Worksheet Functions |