I have a header (row 1) in my worksheets that I need to fill with a specific color (ColorIndex 13 – purple color), but only in the cells in that row that have text. For example, sometimes the header will go to Col H, sometimes to Col K, etc. Trying to write a macro that will only fill the row with color with cells that contain text.
Help is much appreciated, thanks!
Hello MSmithson,
This will color only the cells in row 1 that have text.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Couldn't you use Conditional Formatting rather than a macro?
Select Row 1
Conditional Formatting > Use a formula ...
Formula:-Apply your format colours to fill and font as required.Please Login or Register to view this content.
ColorIndex 13 – purple is rather dark, you might want to make font formatting
colour:= white.
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks