font color

  1. J

    Formula to count partial colored font using wildcards

    Good morning, I am having a problem counting colored font while using a wildcard for a partial search in a cell. The font color I want to count is "Green" which only appears once in each column to show a winner's name a long with the winning number. Ex: "5. Stephen". The number and name have to...
  2. N

    Formula to change font color in part of cell only

    I have a large table of prices. The column headers in the top row have titles with some duplicates which can't be changed. I can't break up the table into more than one. Those column headers in the top row also are used to produce a validation list. But that list first shows up in a spill list...
  3. CodeSkittle

    VBA Macro Xlookup Function Based on Text/Font Color

    Heya I don't know much of anything about VBA or coding or whatnot so please forgive any ignorance I may have but if someone could create a macro for me that would be amazing! So I have an excel spreadsheet where I keep track of various entertainment I enjoy and in particular shows and any...
  4. D

    ActiveX Button to Change Font Color of Other Buttons

    I'm working on a simple sports stat tracker. I'm using ActiveX buttons to track player fouls. I'd like to be able to see at a glance what fouls were in the first half vs the second half. Here's the VBA code I've patched together so far: Private Sub CommandButton2_Click() Dim x As Integer...
  5. R

    Macro Help! Change Cell Color for Errors and/or Zero Values to White - Across Whole Workbook

    Hello Macro Wizards & Wizardesses... I have a very intricate workbook with several dynamic pivot tables, slicers, links, etc. I've applied conditional formatting to each sheet to handle turning the font color of cells containing either errors or zero values to WHITE which works great until I...
  6. D

    Help Cleaning up Font.Color Keycells Macro

    Hi all, I'm trying to change the font color in a range when the cell in column G changes. The macro below is only working for the first row (row 8). I imagine this would be easier as a loop but I couldn't figure it out. There are many different font colors and each cell already has...
  7. D

    Font color and size change

    Hello i have a program to extract data from cell and print it to the outlook but the problem is ,in one particular cell i have changed the font color and size but its is getting printed into the outlook as it is in the cell, it just print the default font size and color ... is there any solution...
  8. A

    Insert a line of different colors of text into word via VBA

    I am inserting text after a bookmark in word via VBA. I want the make the second part of the line be red. Is there a way to specify in code that only part of the inserted line needs to be a different color. My code is as follows: wdapp.ActiveDocument.Bookmarks("txtbx3").Range.InsertAfter "1-A...
  9. J

    Counting Red Font Cells

    I found function instructions to count cells with red fonts and it works fine. (My Thanks to Mike) However, the next step for me is to count the red font cells that are less than the value of 20. I've tried to combine the instructions with both IF and And formulas and both have failed...
  10. G

    Partialy Change Font Color to Another Color

    this code change the red font color to green font color.... it is working code but getting error msg can you solve this Public Sub FontColorInCellPart() Dim c As Range Dim i As Integer For Each cell In ActiveSheet.UsedRange For i = 1 To Len(cell) If cell.Characters(i...
  11. K

    Identifying new data with certain criteria

    hello! I have a worksheet with several tabs. I want to take the data from one tab and apply it to another . This is a sample of the info from tab 1. <tbody> 0750010204 Dynamic 0750010205 Dynamic 0750010205 </tbody> What I want to do is apply the information to the new tab so that...
  12. C

    New TWIST on LOOKUP Match n' Copy to diff sheet -- using font color as part of the required criteria

    Ideas on vba to do the following: On Sheet1, starting w/ Column AC, Row 4 take the first cell (that has red font) and try to locate a match on Sheet2 within Column C, starting with Row 2 going down. =If match found, turn background of that cell on Sheet1 to blue. =If not found, move to next red...
  13. D

    Best method for automatically changing an entire row's fill/font color based on one cell

    I have a master list of contact information that I color code by hand depending on a designation I give each row. The designation is just a single letter, "X" for example, and is listed under it's own column within each row. In the example below, I'd want rows (not just the cells A1 and A3) 1...
  14. E

    Ctrl Shortcut to Change Font Color of a Active Cell

    Can you let me know how to change the font color of a individual active cell by using the ctrl key? I used this command before but I believe that it was built into a macro. Thanks.
  15. A

    Font style and color in a string

    Greetings, I am imputing defined string variables into a cell. I need only certain parts of the text to be red and bold. Example. Example. HospSheet.Cells(curRow, DX_LABEL_COL).Value = PreDXLabel & "Billing DX:" & "RDXLabel & "Revised DX:" PreDXLabel is fine as standard text, but everything...
  16. D

    VBA ~ Need help with counting each code based on font color with no strikethroughs.

    I am creating a report that analyzes pre and post occurances and need to count items based on a 4 character code, that matches a font color but has no strikethroughs. I have a matrix that I reference for the 4 character code, it's description, and last the count...for which I need the formula...
  17. M

    Change font in graph

    Hi, I inherrited this script from someone else and can't really understand it. What the script will do is create a graph with all kind of balloons. Within this balloon a number will appear. Now the problem is that the font of this number is white. This is hard to read so we want it black...
  18. C

    Conditional Formatting Based on the Font Color of the Linked Cell

    I have been working really hard to make a spreadsheet super user-friendly for an office manager. The last thing I want to do, I can't seem to find when I Google it. What I have are 2 tabs: INPUT and LOGS. The INPUT tab is for doing just that: input the information and it will populate into the...
  19. T

    Help debugging macro

    I'm getting a debug error and I can't figure out why. It's telling me that I'm using an "Invalid or Unqualified Reference" and it highlights the line .Font.Color. Any help would be appreciated. Thanks. Sub ColorCells() Dim rng As Range Dim cell As Range Set rng =...
  20. J

    Excel formula based off cell font color

    Hi all, I am trying to create a formula/macro in Excel that would take a number in a cell and if the font color is blue add 25, if its black add 10, and if its red add 5. Any clue as to how I could do this?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back