color

How can I filter multiple columns by color?

Does anyone have a good method of identifying cells that need to be modified in a spreadsheet to make it easy for the user to locate? I have not been able to find a way to highlight a cell or change the text color but not have them print in that manner, since I have color images on the form I...

I've got a List with player names and whether they shoot right or left (NHL). The players names who shoot right are colored red. When I use the dropdown list I want the red color to remain with the name. How do I accomplish this? Thanks

Hello Fellow Users, I need help concatenating two columns and retaining the color format located in column B. Please see the snapshot below. Can someone help me with the VBA code? Thank you! Column A (A1:A200) Name Column B (B1:B200).....Column B text color: RGB (47, 117, 181) Lname...

I am trying to create conditional fomatting that changes the background color of a cell based on a simple conditional formula, but I want the color to come from the background color of another cell. For example, assume I want to create conditional formatting that changes the background color of...

Sheet1 is data Sheet2 is data with fill color Abit hard to use conditional Formatting as i have at least 411 data with fill color Is there anyway to do it?

Dear Team, I am using the mentioned vba code to find text in font color red in powerpoint . The below mentioned code i was using to find red color font text in ms word. Sub newred() Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorRed With Selection.Find...

Hello everybody, I'd like to use a vba (or formula, whatever is the less resource intensive) to set fill color of a cell based on a column value. For example, if I have a column with number 1 then fill the adjacent column with the color table value of that number. I've grown quite frustrated...

When I select any number of adjacent cells (could be in a row or a column), anywhere on my spreadsheet, I would like to then press a form control button that will fill the interior color with color the 16738047. I have tinkered with several codes I've found online, but so far they only color...

Good afternoon, Nice for for somebody for a Friday afternoon! :-) I know how to use the 56 .ColorIndex values, and how to set an interior or font color to an RGB value, but does anyone know of a quick way to return the RGB value of each element in the Standard Color Palette (Excel 2016) to a...

I have a column that looks for duplicates, and makes them fill color and font color red. What I would like to do if possible is in another column look at conditional formatted column and return text\values or anything that has a duplicated cell which is fill color red and font color red. Is...

Hi, Is there a way to use a transparent conditional formatting to put a "shade" over cells with true? The result i'm looking for is let's say a cell has already been manually highlighted with a specific color, if the conditional formatting is true, than a color with transparency will be shown...

Hello - Thank you for any help in advance. I'm still trying to learn VBA and have been trying to figure this out for a while - and need some help. I am trying to make certain fields required before the user can access the print button I created using the form tools on a specific worksheet. To...

I need to color code a group of cells every time a value changes. For example, in column A, I have the word Truck in the first 5 cells, then the word Horse in the next 5 cells, then the word Plane in the next 8 cells, etc. I need a formula to color cod each group of cells whenever the value...

The below code will allow me to type the number of times to copy a sheet. Dim I As Long Dim xNumber As Integer Dim xName As String Dim xActiveSheet As Worksheet On Error Resume Next Application.ScreenUpdating = False Set xActiveSheet = ActiveSheet xNumber =...

I need a formula for conditional formatting that will color a font based on the condition that compares the value in H12 through S12 to the value in H13 through S13. If line 12 is of lesser value than 12, color the font red. thanks in advance

Hi everyone, For an app under development, I need the user to: 1) Select a range of rows within a single column (say, A5:A15) 2) Color the background of the selected range. 3) Click on a button that opens a UserForm where the selected range is shown ( e.g. within a text box in the UDF, labeled...

Hi guys, I found this VBA code (here: https://www.extendoffice.com/documents/excel/2129-excel-highlight-active-cell.html) <code class="vb keyword">Sub</code> <code class="vb plain">Workbook_SheetSelectionChange(</code><code class="vb keyword">ByVal</code> <code class="vb plain">Sh </code><code...

Hi all, is there a work around for coloring a tab in a shared workbook. i have a workbook which myself and another share for my supplier accounts and the tabs are colored depending on if they need to be actioned. i update them by coloring the tabs Red, Orange & Green on the tabs themselves and...

I have the current VBA code below: Range("N82:S82").Select Range(Selection, Selection.End(xlDown)).Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorAccent4 .TintAndShade = 0.399975585192419...