| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove fill color for cells without text only
Thank you, Gord Dibben!
"Gord Dibben" wrote: For Each r in ActiveSheet.Range("G2:G477") Gord Dibben MS Excel MVP On Mon, 26 Nov 2007 15:16:01 -0800, Studebaker wrote: Hello Gary"s Student, I've run across the same situation I need it only for column G rows 2 thru 477 (ex: G2:G477). Can you tell me how I can type the macro so I can just remove fill color for only cells without text for just that area of my spreadsheet? Thank you for your help! Studebaker "Gary''s Student" wrote: try this little macro: Sub fillout() For Each r In ActiveSheet.UsedRange If Application.WorksheetFunction.IsText(r.Value) Then Else r.Interior.ColorIndex = lxnone End If Next End Sub -- Gary''s Student - gsnu200755 "Studebaker" wrote: Hello, I have a huge spreadsheet where I need to remove the lavender fill color only on the cells that have no text in them. (I want to keep the lavender fill color in the cells that do have text.) I tried Find/Replace but it tried to remove the fill color for every cell. Can someone help, please? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
| Shortcut for FILL COLOR and COLOR TEXT | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Threaded Mode
