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