font color

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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 =...

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?