Insert a new module from Insert menu. how to change color of buttons How to change color of buttons in microsoft excel 2010 i tried the record macro thing but still i cant find the option fo. Click the button again when finished. The advantages of an Excel table include all of the following: Quick Styles. Click the Page Color button; Apply No Color command in the Page Color button drop down list. Then, click the intended workbook. How to change background or font color based on cell value in Excel? When you deal with huge data in Excel, you may want to pick out some value and highlight them with specific background or font color. KnownColor attributes. Here Mudassar Ahmed Khan has explained how to dynamically change GridView Cell Background Color based on condition in ASP. , gray) to fill your Windows desktop. Here you can find or see how we are changing back color property of list box manually or using code. At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go. After this navigate to ‘Format’ > ‘Sheet’ > ‘Background’. Here, you can change the background color of a cell when double clicking it or right clicking on it with the following VBA code. How do I change the color of an Active X control button? I need to change the color of an ActiveX control button to a certain RGB color (0,113,188). Change Form's Background color on Button Click Step 1- First open a new F# project Using Visual Studio 2010 and select F# Windows app template and give a name to project. If you'd like to highlight text or numbers to make the data more visible, try either changing the font color or add a background color to the cell or range of cells like this: Select the cell or range of cells for which you want to add a fill color. Highlight the range of cells to be sorted (H2 to L12). However, for those who care about the aesthetics of their device, it also serves a decorative purpose. To change the name of the grid format, enter a new name in the Grid Format Name field. Therefore, we have one background color for the table, and a different background color for the table header row. In terms of text and background color adaptability to specific visual needs it is a step back when compared to Windows 7. Hovered items control the look of buttons when a mouse cursor hovers over them. Later you can change the formatting or background colour of the selected cells to make them stand out from the rest. 5 , jquery-datatables I have implemented the Save as Excel, CSV, copy and print tools in my website, and it is working perfectly when I run the website locally. In Microsoft Word, you can apply a background color to an entire table or even just to specific portions of a table. Submitted by ravisagar on Sun, 02/10/2008 - 16:42 How to change the background color of entire row in Excel using VBA code - Conditional 2008-02-10T16:42:21+00:00 My friend Vinod gave me a problem to change the background color of entire row to Red and also to change the font to bold. White is used as an example. 5 in a row If I click on one of them, the color should change. This short tutorial shows a couple of quick ways to clear formatting in Excel, and explains how to remove only specific formats in selected cells. ColorIndex property using Excel VBA. When working with large Excel worksheets, it's a common practice to apply different formatting options to make data relevant to a particular situation stand out. Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot. Here I use column with a bool value and change the colors for true cells. This one line code would fill the cell A1 of the active sheet with red color. Title Bar colors. Specifically, use the Back Color property to change the background color. In excel, cannot figure out why background color for a cell will not change? 4 answers 6/15/2012 I'm having the same problem as a previous user's query (linked below) wherein I can't change the font or cell shading color on an Excel spreadsheet. Click on the Home tab of the ribbon. Next, change the Property to Front Panel, (not Front Panel Window). Microsoft Office Excel 2007 displays the Open dialog box as the figure: If you cannot see any existing workbook (Excel file) that you intend to open in the File List (on the right), click drive or folder in the Navigation Pane (on the left). Click Apply button. I'm working on a simple Excel macro to change the background color depending of the cell value. Within the “Fill” section, select “Picture or texture fill”, click the “File…” button, and select the jpeg file you created. Change the Font Size, Color, and Style of an Excel Form Control Label Anyone who has used a Form Control Label likely knows its limitations: you can't increase the font-size, -color, or style. Tips and formula examples for number and text values. After Click OK. Character code 128, or letter “q”. I cannot for the life of me figure out why it wont let me change the background color of certain cells. I have always had the problem of not getting a transparent background color for my images or other things i code which includes a background; for instance, i had a logo which i designed and the background was white but i wanted the background to be transparent, so i could include it in other containing stage where the background colors were different from white and didn’t match. But sometimes, you need to change the grey color to a beautiful color to make the worksheet more professional. Theme color can make dramatic change on your presentation without to change the theme. In Excel 2007, click the Office button and then click. If it's Something that changes and you just want to be able to click and change color then use one column with whatever color you want then use format painter and click on the other columns. There are only two things left to do, now: change the background colour of cell C1 from white to green, and centre the text. The CSS is very similar to last time with a few notable changes. 1) Change Cell Background Color based on Condition In the first example, I'll show you how to change the background color of a cell or multiple cells based on a condition. If the site you are creating c In HTML, how do I change the color of the text and background of a web page?. Then you click on the background color—in this case, anywhere on the white. Now, browse through all the available images, select the image that you wish to add and click the insert button as shown in the below image. Today, I can introduce you some quick tricks to change the color of the button in Excel. It does not apply to text, because the text color and the text background color are always set automatically. However, you will have to redo it when the values changes. Here are the steps to create the icon: Select the cell to the right of the cell that contains a validation list. Latest update on November 6, 2012 at 08:19 AM by Jean-François Pillou. A series of squares with information entered into them. Follow Step 1 as above. How can I change the face color of a command button in Excel 2003 (View-Toolbars-Forms)? Changing font color is easy, but I don't know enough about VBA to change the button color. Modify the background color to White so that the balck will change to the default. Hey For the past two hours I've been looking into how I can change the blue background color when I press CTRL+ALT+DEL on my Windows 10 build 16299. Then from the highlighted html elements find the class name and overwrite the class in your alternate CSS. Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML. Calculate the sum of cells with only a certain cell color: 17: write the days of this month to the right write the day to the child cell and color the weekends: 18: Adds cells with red background color between cells A1: d20: 19: collects selected fields in status bar: 20: color change when I come to the buttons with the mouse. Just like you can easily change the colors of your slicers by applying a different style to the slicer it is simple to modify the button layout and appearance, just adjust the numbers in that group of the ribbon. Re: Macro Button To Change Background Color Of Specific Cell Hello bifjamod, Welcome to Ozgrid. Within the “Fill” section, select “Picture or texture fill”, click the “File…” button, and select the jpeg file you created. color row excel c delete every other image click on the arrow button besides first and select all. Below are the step by step instructions for accomplishing this: 1. If the site you are creating c In HTML, how do I change the color of the text and background of a web page?. Here are the steps to create the icon: Select the cell to the right of the cell that contains a validation list. thanks in advance!. While you can create a heat map in Excel by manually color coding the cells. NET Forums / General ASP. Now you can choose the gradient fill or solid fill to replace the pie chart color. Learn the basics of using color in Adobe Photoshop CC, including how to work with brush tools, use the color panel, create a solid background, and more. Use the Fill Color button to choose a solid background color to add to selected cells. Individually changing the cell color for all of the cells in a worksheet can be tedious, as it is much easier to set the fill color for multiple cells simultaneously. Change cell color when cell is clicked with VBA code. A PDF supports only one background per page, but the backgrounds can vary from page to page. Size group. If you click the save button, your code will be saved, and you get an URL you can share with others. Using Themes Themes are new to Office 2010. We do some modest edge smoothing, but not a lot. In this article we are going to learn how to insert and use a toggle button in Excel worksheet. Go to Data>Conditional Formatting and specify your criteria and the formatting accordingly. Step 6: Switch to Folder View tab. Following these steps in order to modify your Office background color: Open any Microsoft Office 2016 application - this can be Word, Excel, PowerPoint, OneNote, Access, Publisher and obviously Outlook. Excel allows you to print your document as well as to add additional page layout options to your presentation. Change Color of Next, Back, and Submit Buttons and the Progress Bar You can easily change the color of the Next, Back and Submit buttons as well as the Progress bar on the Style tab of your survey. Conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell's value How To Home tab Styles group "Conditional Formatting" button Click Data Bars *If you want to edit the data bar, click "Manage Rules". White is used as an example. I had to create a new theme and change the Window Color to gray. You’ll be relieved to hear that adding ActiveX controls in a worksheet is easy, but it is after you have learned few basic things about how to use them. Hide a row and the color bands adjust automatically. From the dropdown ‘Choose commands from’ select the option ‘All Commands’. Excel 2002 SP3 Win XP Pro SP2 Hi, How can I change the font and background color of combo box I am using? Change color font and background combo box. well make the buttons in array when you click the button search all of them if they contain the color you want to set on this one and return the one that have it to the original (what ever you want to be the original). Choose the fill option that meets your design needs by selecting your desired color, or by clicking the "Fill Effects" button to view additional options. Using VBA and Excel 2002, how can I change a tab color whenever any cell on that tab/sheet has its interior color becomes equal to index 4 (green)? What I'm trying to accomplish: Cells on a sheet contain conditional formatting that when given a certain condition will change the interior color of that cell to green. However, the background created is static. Go to Data>Conditional Formatting and specify your criteria and the formatting accordingly. Use the Fill Color button to choose a solid background color to add to selected cells. To access the ActiveX toolbox. CSS The idea is a box with zero width and height. Then you click on the background color—in this case, anywhere on the white. How to set background color in pushed button of Option Group. Posting your question in threads started by others is known as thread hijacking and is a violation of the forum rules. His task was to add the contents of certain cells based on their background colors. UPDATE: This method also works in Windows 10. Currently, 74% of websites use different colors for visited and unvisited links, making this design approach a strong convention that people have come to expect. Choose a background color for the left navigation pane, choose a text color (if you want) and then click Apply button again. Character code 128, or letter “q”. To change the color theme, select an option from the "Office Theme" drop-down list. ‘Go to Special’ option has a radio button “Formulas” and selecting this radio button enables it to select all the cells containing formulas. Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Then re-enter the Password and all your excel formulas are hidden. Click the Format Painter button in the Clipboard group of the Home tab. In the example below, the Button control's Click event handler opens a ColorDialog component. And stop here. Excel 2002 SP3 Win XP Pro SP2 Hi, How can I change the font and background color of combo box I am using? Change color font and background combo box. From the Navigation bar, select Account. Select the cell or range of cells you want to format. For any question, please email me. You cannot change anything about the data in Word, and will again have to double-click the object to open Excel to make edits. Select the arrow-button from toolbar and move your mouse to page until you find required area. Select a color, click OK, and the background color of the HTA will change to the color you selected in the dialog box (really; give it a try and see for. You can also change your default font and default font sizes, as well as a few other options, from this menu. Here’s the HTA code:. Adjustable features include messagebox background, message font and color, button captions, fonts and tooltips, dialog position, dialog icon, timeout and more. Right-click it and select ‘View code’ from the context menu. change row background color excel vba how to use excels conditional formatting highlight the same. To apply highlighting or a background fill color to cells in a worksheet, you would choose _____. You can no longer post new replies to this discussion. As long as we’re on the subject, here’s a nifty little HTA. I have managed to get my Excel, Word and Notepad to all show light gray background by default by changing the Windows Theme, which works well for me. Change the alternating color. Solid color - Allows you to select a solid color (e. There are many different shortcuts for selecting elements in Microsoft Excel tables. For a single font, you can click the little middle “Quick Use” button (a right arrow in a box). Select cells C4 through C7 and go to Conditional Formatting –> New Rule… on the Home ribbon. wsite-button-normal,. Hover background color for the buttons on the Welcome page. I had to create a new theme and change the Window Color to gray. > Subject: Re: [visualbasic-l] Change the text color of the vb command > button > > > You can use a Checkbox > Set it's Style to Graphical, and it looks like a Command Button. Today, I can introduce you some quick tricks to change the color of the button in Excel. In this article, we are going to see a detail description on how to make a pie chart in excel. We can change the Worksheet tab colors by setting the Tab. In the properties windows, select BackColor. Right now they are gray but I would like to change their background color, not just the text color. To summarize, Excel Color Commander can help you capture colors from any webpage, from cloud color generators, photos, corporate logos, images or even another dashboard. Figure 8: Background Removal in Outlook 2010's Ribbon. To finalize the distinction between a regular form button and the HTML 4. The GridView Cell's background color will be dynamically changed based on its value in the RowDataBound event of GridView. If you used styles in other programs, you’ll be familiar with the concept: a style. Posted by Patete on August 30, 2000 10:35 AM I have seen buttons within EXCEL spreadsheets that are colors other than the gray color that is normally on buttons. Using Excel VBA code, we can change the font color as well as the background color of each cell effortlessly. Although grid lines in excel have their own benefits but in some cases it is better to hide them. Excel's Live Preview lets you see what the cell selection looks like in a particular fill color when you move the mouse pointer over the color swatches before you click the desired color. To use a pattern with two colors, pick a color in the Pattern Color box, and then pick a pattern in the Pattern Style box. One final step will make the quiz look better. Title Bar colors. In this method first you can check the value of cell in the column with the GetColumnValueAtRow method then set the brush you want, fill the cell rectangle then write the text with your proper font. Use the Fill Color button to choose a solid background color to add to selected cells. Select a table element and click the Format button to format that element. How to multi select cells or ranges. Columns and ComboBox items added to the ListView. Change color for gridlines in Excel By default, gridlines are displayed in worksheets using a color that is assigned by Excel. Size group. Now tap on Google Keyboard and then head over to Appearance and Layouts. Indeed, I can change the button background color in the dialog editor (general tab of the button properties) but when I run the macro the background color of the button remain gray. I already have the button programed to run an import upon click and would like the button to change red after import is complete Access 2010 change button color on click?. By default, gridlines are displayed in worksheets using a color that is assigned by Excel. This is why I need to change the background color of this particular folder. The GridView Cell’s background color will be dynamically changed based on its value in the RowDataBound event of GridView. How to change background or font color based on cell value in Excel? When you deal with huge data in Excel, you may want to pick out some value and highlight them with specific background or font color. Description: It is an interesting feature in excel, we can change background color of Cell, Range in Excel VBA. CheckBox BackColor Property: Change Manually. Since you cannot yet change the Color Scheme of Office 2013 in this first preview, here's how to customize. Example 3: Show Data Bars Instead of Color Shading. So my question is if there is a way to change just the color (or another property) of an already stylized component. Hello, I'm struggling to set the background color on buttons in Excel 2007. To make your accent color appear on the Start menu or screen, the taskbar, and the action center, set the “Show color on Start, taskbar, and action center” setting switch to the “On. That was what I was afraid of. Here, you can change the background color of a cell when double clicking it or right clicking on it with the following VBA code. Finally, I set the Back Style property of the controls to "Transparent. Is there a way I can use conditional formatting or something to change the color of the cell once I enter a value or text into that cell? For example if I currently have the A2 cell color as a gray color, and I enter information into A2 can I have it set to automatically change to no fill or any other color without having to click out of the cell, back into it, and then clicking the button??. How to set different colors for items in ComboBox I have list of items for combobox, I need to set color to items, based on some conditions , so how to. We all know about Microsoft's latest Office suite "Office 2013" (codename Office 15) which is currently under development and a free Customer Preview version of Office 2013 is available for download. Table Names. Change to percent. The recommended contrast ratio between text, icon, or button color and background color is 4. wsite-button. Now let’s add in what’s missing using the “Mark Areas to Keep” button. So I have 2 textboxes A and B which by a commandbutton click gets populated automatically. I want it to change back to the original color when a separate macro is run. I am using them because they are usable on macs and pc's. Change the Background Colour of a Cell. Change the Task Bar Color in Windows Vista. While you can create a heat map in Excel by manually color coding the cells. For that, I agree. However, I would like to use this Macro to be able to quickly change a cell to different fills or patterns by just clicking the button. In the dialogue box, as shown above, the color which you have selected will appear under the Sample at the bottom of the dialogue box. Specify the start and end date, before running the macro. This page shows you how to use some of these browser display settings. You can find the jsfiddle in here This piece of code uses JQuery. To change the background color of a picture in Photoshop, first, click on the “Quick Selection Tool”, which should look like a paintbrush with a dotted circle around its tip near the top of your tool menu. With the extension, you can toggle the feature on and off or customize your settings on a per-site basis. How can I change the face color of a command button in Excel 2003 (View-Toolbars-Forms)? Changing font color is easy, but I don't know enough about VBA to change the button color. 2) Locate button css codes. You can fix the position of a background image so that its position is fixed even if its containing block scrolls. This one line code would fill the cell A1 of the active sheet with red color. My question is i want to change default background color of button and hover color of button also. Change the second box to not equal to and change the format color to red. When I click the macro button, the cell I had selected changes colors. I'd like to know how to change the background color of my Contact Form input boxes from Transparent to White. Following these steps in order to modify your Office background color: Open any Microsoft Office 2016 application - this can be Word, Excel, PowerPoint, OneNote, Access, Publisher and obviously Outlook. DataTable dt = new Datatable(); --> assign this table with some values from database. Using 3-digit, or shorthand, HEX codes is not a great idea. The following color codes are taken from the HTML specifications, whose names correspond to the names given for the. How to set background color for the buttons in TableTools? How about different colors for different custom buttons? For example, NEW with blue background and. org for more color palettes. I already have the button programed to run an import upon click and would like the button to change red after import is complete Access 2010 change button color on click?. The Microsoft Office 2007 color scheme certainly fits in Windows Vista, but fortunately for those of us unhappy with so much light blue, the color scheme can be changed. We’ve gotten interest in Background Removal from other groups within MS, but I don’t know of any plans to expose it through. Before learning to conditionally format cells with color, here is how you can add color to any cell in Excel. Slideshow - Displays a series of photos from your computer's default "Pictures" folder in a slideshow. Three easy ways to use color in an Excel worksheet. Do you want to change the look of your forms’ buttons? WPForms allows you to make basic customization on your buttons using the drag and drop form builder. To change the background color of a picture in Photoshop, first, click on the “Quick Selection Tool”, which should look like a paintbrush with a dotted circle around its tip near the top of your tool menu. Move to another sheet and watch as Excel colors the tab. So, let’s see how to effectively use a pie chart and add rich data labels to your chart, in order to present data, using a simple tennis related example. Since we want the button to be right next to the search box, we’ve given it a relative position. Check the second level "Disable all Macros with Notification" and you are set. It should be noted that while the taskbar color will change, the Start Button will always remain green. Excel 2002 SP3 Win XP Pro SP2 Hi, How can I change the font and background color of combo box I am using? Change color font and background combo box. There's CMYK white (absence of ink) and HSB and RGB White (Additive Blended Light becomes white). Change cell color when cell is clicked with VBA code. Also how do you do this for the Submit button on the Contact Form also? It should be just as simple. I'd like to know how to change the background color of my Contact Form input boxes from Transparent to White. How to assign a VBA Macro to change the color of ActiveX command button in Excel. For displaying the whole background color of the worksheet, you need to change the checkbox's background color to be transparent. Go to Data>Conditional Formatting and specify your criteria and the formatting accordingly. In Excel, when you insert a command button, the color of the button is grey by default. Excel Shape Fill: Here you can select a color, gradient, picture or texture to fill the selected element. Change the page background color in Word 2007 documents. Click the button next to the theme color you want to change (for example, Accent 1 or Hyperlink), and then pick a color under Theme Colors. Per say here is what I am trying to do If a certain "word" is used from the drop down list I want the background of that cell to change its color to "green. Java script functions from text - changing background colours 2 This page shows how a function can be called from java script by using a text link. Here will demonstrate how to design Excel background color regardless whether Microsoft Excel is installed on your system or not. Read More Create A Thermometer Visual To Display Actual Versus Target. Then select your worksheet that you want to have the background color and use a conditional format to define that color. This data is displayed on graphs (so I click the button and different data is displayed on the graph). Every worksheet you insert now is based on this template worksheet. If the cell is not True, then the color is not applied. We can make a button in HTML using input type tag. Hello, I'm trying to figure out how I can change the color of a button when I hover over it without changing the color of the text. wsite-button. Follow Step 1 as above. Background Color for Table Row. On the Fill tab, under Background Color, pick the color you want. Here are the steps to create the icon: Select the cell to the right of the cell that contains a validation list. It's nice to have classes for each direction possibility. Give a table a name to make it easier to reference in other formulas. Change Form's Background color on Button Click Step 1- First open a new F# project Using Visual Studio 2010 and select F# Windows app template and give a name to project. I know you can do this by changing the background color of a cell. This will help make the keyboard shortcut to access them shorter. Is there a way I can use conditional formatting or something to change the color of the cell once I enter a value or text into that cell? For example if I currently have the A2 cell color as a gray color, and I enter information into A2 can I have it set to automatically change to no fill or any other color without having to click out of the cell, back into it, and then clicking the button??. You can fix the position of a background image so that its position is fixed even if its containing block scrolls. I've played with the hover function but whenever I use it, it only changes the color of the text. as well as using html to change a color Changing colors - Google Sites Help & Designs Search. Say you want to change the background color of a Button. Currently, 74% of websites use different colors for visited and unvisited links, making this design approach a strong convention that people have come to expect. Whenever an item in the list is updated with the status in the column, then the background color of the status column should automatically change depending upon the status. TimerInterval =0 under the On Click Event Procedure of the Add New button. We can change the Worksheet tab colors by setting the Tab. Or we may change font colors and sizes for headings. If the cells have no fill, gridlines will be visible. The text color of a button that the mouse pointer is over (which would be ButtonText when the mouse pointer is not over it). Or we may change font colors and sizes for headings. Color = vbRed End Sub. This can be accomplished with the little touch of CSS (Cascading style sheets), such as the following rules: background-color:whatever_color;. Previous: Find the data passed with the on() method for each. I want it to change back to the original color when a separate macro is run. Character code 128, or letter “q”. misc font), and Background Colour (button). Every worksheet you insert now is based on this template worksheet. Decrease. Microsoft Word also provide the simple tool for that. The background can be as simple as a solid color, or you can use an image. Use the Fill Color button to choose a solid background color to add to selected cells. I right click and I see no option other than to change the font color. Filling a macro button with colour ( color) and border formatting & I would like to change their individual background colours ( colors) and bordering so as to. When I click on any of the buttons in the "Save CSV Files" frameI have a macro that runs and performs a certain task. Net; Background-Color Attribute in Select; How to pass Ctrl+C to the background application in vb. Good luck! Do let us know if you're unable to change the color of taskbar and Start in Windows 10 even after following above mentioned directions. Solved: Change color of background in MultiPage Control for UserForms If this is your first visit, be sure to check out the FAQ by clicking the link above. Under “Select a Rule Type,” leave the default selected (Format all cells based on their values). In the worksheet you will change the cell color when clicking on it, right click the sheet tab and click View Code from the right-clicking menu. We may want to highlight the font in red if the values are negative, in green if the values are positive. You can read it for yourself. From the Home tab, click the Conditional Formatting button. For example, if you're working with sales figures, you may want to apply a different color to a column, row, or cell that contains totals. Based upon a range of values you can show the Red, Yellow or Green indicators in the cell. How to Change the Selection Highlight Color in Mac OS X Jan 7, 2015 - 14 Comments Many Mac users probably don’t think twice about the color that shows up when they select and highlight text or some app elements in Mac OS X, which defaults to being blue. The new Office 2013 Preview has 4 different toolbar backgrounds to choose from, or none. To view you formulas again simply visit the ‘Review tab’ again and unprotect the sheet. exe represents colors as a pair of hexadecimal digits, where the first digit is the background color and the second digit is the foreground color (i. Bottom line: This video series explains what the Personal Macro Workbook is, how to create it, and why you should use one. Here Mudassar Ahmed Khan has explained how to dynamically change GridView Cell Background Color based on condition in ASP. But firstly, we've not tried all of these ourselves. Now let’s add in what’s missing using the “Mark Areas to Keep” button. Is there a way I can use conditional formatting or something to change the color of the cell once I enter a value or text into that cell? For example if I currently have the A2 cell color as a gray color, and I enter information into A2 can I have it set to automatically change to no fill or any other color without having to click out of the cell, back into it, and then clicking the button??. Cell static format for colors. It's nice to have classes for each direction possibility. We do some modest edge smoothing, but not a lot. It covers entering data, formatting, cell alignment, fonts, mathematical calculations, functions, and much more. When you right click on the button, click on properties and change the "BackColor". Determine the background color you want to use. You can use the Defer Layout Update option to stop excel rebuilding the pivot table layout every time you make a change to the field layout. Press F5 to see the output. In the Page Setup section click the Background button. Latest update on May 9, 2012 at 01:18 PM by jak58. CCM reaches more than 50 million unique visitors per month and is available in 11 languages. To change the color theme, select an option from the "Office Theme" drop-down list. The buttons are in a sheet (not in a form). However, you will have to redo it when the values changes. Any help will be appreciated. As a part of a spreadsheet I'm making, I want a macro to change the color of an ActiveX button. After this navigate to 'Format' > 'Sheet' > 'Background'.