font color change

Hi Gurus I found below code for changing the negative number in red. = = = = = Sub One_Way() Dim c As Range For Each c In Selection If c.Value < 0 Then c.Font.Color = vbRed Next c End Sub Source: VBA code to make negative numbers red and positive numbers black = = = = =...

I am trying to use VBA to insert a yellow textbox that has Procedures, Tickmarks, and Conclusion on separate lines. I have been able to do so. Now I am trying get font to change after the headings. Below is the an example and code for trying to get the font unbolded and black after...

Hello Everyone, Need help with the VBA code mentioned in the end. Objective: To find all occurrences of text from Column A in Sheet 1 and replace them with respective value from Column B in Sheet 2 and highlight the replaced word(s). Issues with existing code: The code is not searching it as...

All, I am building a new hire form in excel and for audit purposes when we print certain information needs to be redacted. The best way I've come up with so far is to make a macro that will: 1. select the cells I want to change 2. change font color to the same as the background 3. print active...

Hello and thank you for your time, I am trying to create a custom number format that allows me to create the below example: If the formula for the cell results in a negative number it will display this: (622) Negative If the formula for the cell results in a positive number it will display...

Hi folks... I have one for you. Still a newby here and learning how to edit existing macros. I decided that at the end of this macro, after Range ("f13:o13").Select, I would like this specific cell range font to change from white to green. I am missing something and can't get it to work...

When I copy a spreadsheet from excel into powerpoint (paste special enhaced metafile) the font doesn't change to black even if my default printer is black and white. I'm using Powerpoint 2013. It is possible to get the font color automatically changing from red to black? It was possible with...

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