Re: How to identify a colored cell Hi, it works, but again you have to press F2 and Enter on a cell (x6:x15) to display new results. It does not calculate results automatically. I think its related with mac version. I will try it on my work PC and let you know. When one types 'active cell' into their search feature, one gets the answer 'Go to System Preferences.change the highlight color'. This does not work. The border color of the active cell stayed pale green (I tried to set it to magenta).
If you are working with large tables of data in Excel, you can make your spreadsheet easier to read by formatting alternate rows to be shaded a different colour. There are a number of ways you can achieve this. This lesson shows you a quick and easy way to do it on Excel 2011 for Mac. Configure alternate row shading in Excel 2011 for Mac This method uses the conditional formatting option in Excel that allows you to set the format of a cell or range of cells based on the outcome of a formula. The way it works is to check to see if the current row number is an even number, and then format the even numbered rows with a formatting colour/shading of your choice. It is a bit convoluted, but works well once you follow these steps. Select the range of cells you want to format with alternat row shading.
Click the Conditional Formatting button on the Home menu. Then, click the option you want from the drop down list. In our case, we are skipping the presets (the first five options) and setting up a New Rule. Note that you can also choose Conditional Formatting from the Format menu.
The New Formatting Rule dialog box will then be displayed as follows. The dialog box defaults to 2-color Scale. In our case, we need the Classic option from the list shown in the screenshot below:. Once you have chosen the Classic formatting rule style, the New Formatting Rule dialog will change to show you the related options:. Next, change the formatting option from the default of Format only cells that contain to Use a formula to determine which cells to format, which is the last option shown in the dialog box below:.
Finally, configure the options to look like the following screenshot. You should have entered the formula as shown, and then selected a formatting option from the Format With dropdown box. The formula shown, =MOD(ROW,2)=0 checks to see if a row is an even numbered row. The Format With option lets you choose from several pre-set formatting rules (we'll choose green fill with dark green text for our example) or to choose a custom format. Once you've finished configuring the conditional rule as shown above, click OK to save the new rule. The Manage Rules dialog will appear:. As you can see, this rule will be applied to the range selected.
![Cell definition in excel Cell definition in excel](/uploads/1/2/5/5/125583558/674660161.png)
Click OK once more to see how the selected cells look once the rule is applied:. If you want to modify the rulem, you can get back to the Manage Rules dialog box by choosing Conditional Formatting from the Formatting menu. We welcome your comments and questions about this lesson. We don't welcome spam. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. We know that bots don't read messages like this, but there are people out there who manually post spam.
I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours.
Press Alt + F11 keys to enable the Microsoft Visual Basic for Application window. Click Insert Module to open a new Module and paste below VBA code to the blank script.
See screenshot: VBA: Get traditional hex code of cell Function getRGB1(FCell As Range) As String 'UpdatebyExtendoffice20170714 Dim xColor As String xColor = CStr(FCell.Interior.Color) xColor = Right('000000' & Hex(xColor), 6) getRGB1 = Right(xColor, 2) & Mid(xColor, 3, 2) & Left(xColor, 2) End Function 3. Save the code and close the VBA window.
Select a blank cell next to the colored cell, type this formula, =getRGB1(A16), then drag the autofill handle over the cells you want to use. See screenshot: Tip: there are some other codes can identify the color index of cell. VBA: Decimal value for each code Function getRGB2(FCell As Range) As String 'UpdatebyExtendoffice20170714 Dim xColor As Long Dim R As Long, G As Long, B As Long xColor = FCell.Interior.Color R = xColor Mod 256 G = (xColor 256) Mod 256 B = (xColor 65536) Mod 256 getRGB2 = 'R=' & R & ', G=' & G & ', B=' & B End Function Result: 2. VBA: Decimal values Function getRGB3(FCell As Range, Optional Opt As Integer = 0) As Long 'UpdatebyExtendoffice20170714 Dim xColor As Long Dim R As Long, G As Long, B As Long xColor = FCell.Interior.Color R = xColor Mod 256 G = (xColor 256) Mod 256 B = (xColor 65536) Mod 256 Select Case Opt Case 1 getRGB3 = R Case 2 getRGB3 = G Case 3 getRGB3 = B Case Else getRGB3 = xColor End Select End Function Result: (quickly select duplicate or unique values in a column. Increase your productivity in 5 minutes.
Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:.
![Search For A Colored Cell In Excel 2016 For Mac Search For A Colored Cell In Excel 2016 For Mac](/uploads/1/2/5/5/125583558/134170547.png)
Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.