change font color

  1. U

    VBA: Change Font Color Based on Value

    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 = = = = =...
    • unknownymous
    • Thread
    • change font color check values font color change value and formatting vba "&"
    • Replies: 3
    • Forum: Excel Questions
  2. R

    How to change partial font color in a cell which is found by another cell?

    I want to change the partial font color (red) found in B1 match by column A.
    • Rajib
    • Thread
    • change font color partial content of a cell
    • Replies: 18
    • Forum: Excel Questions
  3. A

    How to change font color in a TextBox wherein the value of the TextBox is on another Cell.

    Hello - I'm totally newbie on Excel VB. i just happened that i have the tool that we use and just editing the code on it. Now, I would like to ask on how can i change the font of my txtBox, if the value of my textBox is 90% or above it will turn it to green, while if 89% below the font would...
    • ayhann
    • Thread
    • cell change font color font productivity textbox
    • Replies: 3
    • Forum: Excel Questions
  4. Z

    Change font color in a text box based on a condition

    Hi, I started recently to learn VBA and I need some help with changing the font color of a value inside a text box based on condition. I tried below macro but it changed the text box color instead of the font. Can anyone help? Sub Set_Color_TextBox()...
    • zinah
    • Thread
    • .solid .transparency change font color end text box
    • Replies: 2
    • Forum: Excel Questions
  5. J

    Conditional Formatting of Approching Date Based on Date in Another Cell

    My team was so impressed with the results of my spreadsheet (thank you very much to forum members Tetra201, jtakw and etaf) they asked for a little more. I've seen many posts regarding formatting dates based using the TODAY formula but it's not quite working for me. This question is for a...
    • jwest510
    • Thread
    • change font color conditional formatting date dates formula
    • Replies: 3
    • Forum: Excel Questions
  6. C

    IF cell is BLUE (AND) is value is GREATER THAN 0% then make font bold red (VBA)

    Need VBA that will scan through COL E locating ONLY blue cells that have a value GREATER than 0%. If true, change font to RED BOLD. The color blue being used is: Red 153, Green 204, Blue 255
  7. I

    conditional formatting?

    I need to make all cells in a row a certain color if I enter any text in a certain cell in the row. Conditional formatting doesn't seem to accommodate?

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top