| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting type of operation
Hi, I have a file that contains more than 2050 rows and therefore I canno use conditional formatting (limitation). What I am looking for is some VBA code that highlights a cell (patter color) if there is NO FORMULA in this cell. This could be valid for a whole sheet, no need to specify a range (bu it would be cool to know both ways). Can anybody help me with this? Thanks in advance, Titus -- titushank ----------------------------------------------------------------------- titushanke's Profile: http://www.excelforum.com/member.php...fo&userid=1999 View this thread: http://www.excelforum.com/showthread.php?threadid=46919 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula setting cell type to blank and conditional formatting | Excel Worksheet Functions | |||
| Excel 2007 not retaining formatting in mail merge operation | Excel Discussion (Misc queries) | |||
| 'plus or minus' conditional operation | Excel Discussion (Misc queries) | |||
| Advanced formatting operation on a cell | Excel Discussion (Misc queries) | |||
| Conditional operation | Excel Worksheet Functions | |||
Threaded Mode
