|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-25-2008, 02:35 PM
|
|||
|
|||
|
Text and Macro help
Hey, Back for some more excel
 What I'm trying to do this time is create a macro that would automatically --- scan through a list - color the blank cell - and write the no. of blank cell in a separate sheet Sounds.. complicated??!!.. Well it does to me.. Here's the pic:  1. The original Data: S. No. , Name, No. of Cars, No. of Bikes. 2. Filtered to people without car. Blank Cells Hightlighted 3. Put it the 'Comment' sheet. 4. Repeated for 'No. of bikes'. And .. Final Comment Sheet:  I know how to record a macro, but have absolutely no idea what the function in this case would look like. Also would any special precaution have to be taken while recording the macro?? And is this actually possible (or some part of it??).. or am I simply crazy!!  Thanks and cheers.. roy 
|
|
#2
08-26-2008, 05:12 AM
|
||||
|
||||
|
Is this a 2007 problem?
An attached workbook is much better than images. Why not use Conditional formatting to highlight the cells? A PivotTable would probably do this, but without dummy data I can't test it.
__________________
Hope that helps. RoyUK -------- For Excel consulting, free examples and tutorials visit my site Check out the free Excel Toolbar New members please read & follow the Forum Rules Remember to mark your questions Solved and rate the answer(s) Where to copy the code to Code Tags: Make your code easier for us to read
|
|
#4
08-27-2008, 04:16 PM
|
|||
|
|||
|
Conditional format blanks as red fill
Did you get an answer yet? I just conditionally formatted a range with "Use a formula to determine which cells to format." The formula is +ISBLNK(..)
Then choose the format red. Is that clear? Did I attach the .xlsx file with this--I tried to.
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| macro to import text file | maacmaac | Excel Programming | 0 | 07-24-2008 10:08 AM |
| Text Box name changing, macro to delete not working | NMullis | Excel Programming | 2 | 03-25-2008 06:43 PM |
| Problem importing text file using macro | welchs101 | Excel Programming | 4 | 12-01-2007 10:21 PM |
| Resolved >> Macro to edit multiple rows of text | J B D | Excel Miscellaneous | 5 | 10-22-2007 05:55 PM |
| Macro to detect bold text | tryer | Excel Programming | 3 | 04-11-2007 07:05 AM |
Linear Mode
