Excel VBA - Font Color

Excel VBA - Font Color
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[@TutorialsPoint_]

Get Certified in Excel VBA:bit.ly/41fWeVP Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@shrikantdarekar8387]

Hi Sir, Your coaching is simply amazing, a non developer like me even can understand all the points which you explained in series of videos. its a gift for me.

[@mohon321]

This is a great tutorial on Excel VBA. I have never seen a series like this. Thank you.

[@Karthik236]

Hi Pavan, you are great man....i have not seen such a lucid and clear explanation in all your videos. God Bless!!

[@JantaAndriImuly]

This channel is so so brilliant! thank you!! Regards from Indonesia.

[@sudhanvamahamuni3191]

Great Pavan. Simple to knowledgeable video. God Bless you for sharing such valuable stuff.

[@NitinGrewal]

I like your tutorials. Just one thing to point out - it is not called magneta, but magenta.

[@kacknowledgeaboutcomputer5517]

Tq sir for your explanation , Is superb I learn VBA form your tutorial The way you explain in english lang. with easy words I like it so much .

[@attilaguba856]

Thanks Buddy! I could use it inside the If statement , nice one!

[@exogendesign4582]

Damn I thank god I found your channel it help me a lot.

[@jaswantdn7]

You are doing a good job sir...thank you ..

[@ramesh.alluri6733]

really great trainings sir. sir if I want to give different colours for different sets in Colomn A. ex. if column A is different countries and Colomn B with codes. I want different colours for each country set and codes

[@doubletoned5772]

Great video. Just a small correction. The name of the color is vbMagenta and not vbMagneta

[@evi4822]

How to change font in whole sheet? Or we usually use ctrl+a in excel sheet.

[@arielzabatecuizon5147]

How can I assign values that includes the formats like if it is bold. For example cells(1,2).value=cells(1,1).value but it must include the bold format from cells(1,1).

[@sharadmoktan6874]

My query is: If the stock level falls below the minimum level we can do a conditional formatting in excel and show the present stock as red color or set ut to blink. And in the same way what would be the VBA code to show the same minimum stock level in listbox .

[@thirupathikalavala5426]

Hi Pavan, you are really a unique in VBA teaching, i am trying to color the concatenate formula like this ="ABC"&(A1)&"buy"&(d2)&"from DBC". here, i need to apply the values or text of cells A1 & D2 . can you help.

[@VenkateshB23064]

What is difference in using the prefix as xl and vb?

[@sophanasorn6218]

Great job

[@tirumalaraonh5626]

can we get the sample file so that we can work on it

[@DeepakSingh-yg7wt]

Wonderful every video. Thx

[@firozhasolkar3759]

Hello Pavan, what if I want to hide text with a particular color in a "Cell"... for example in cell data is "My name is Firoz"... Firoz is in blue color and I want to hide blue color text so can you help me out with VBA code...

[@upgradetechnicalskills3392]

How to highlight active cell front in Excel workbook with the help of VBA

[@ShahAlam-ye8vd]

very very easy to lean vba

[@rnunez047]

¿Qué te hiciste en estos 5 años, dónde estás?

[@argenisaguilar9045]

Grat..thanks so much

[@rajaumesh3664]

simply superb

[@cpacharya3214]

Your vbMagneta didn't work, coz ots Magenta

[@brijeshkumarpatel1011]

Nice sir

[@rashmipanda1560]

Is there any way to change the input characters color in an inputbox. I want to hide my password

[@pintuclassespatna]

How to write VBA in power point for font color change Please reply sir

[@tryingtokool]

gr8 Job

[@pankajsingh-pe3dm]

Thanks sir .. I think it should be yellow instead of yello

[@ParshantRai-nb5nj]

Thanks , Yellow had not worked might be due to spell error

[@sidhantsrivastava4720]

With Block could be used here it will be much easy to type

[@kerssful]

Thank you!

[@dipu1991able]

Hiii, How to get colorindex number?

[@hardikgujarathi1202]

How can i get excel sheet

[@Karthik22ng]

'My Reference With Range("A1") .Font.Color = vbGreen End With

[@jjelpesocondor6591]

4:15, yellow didn't wok, because the spelling of yellow was wrong (vbyello)...

[@andriciflorin6091]

also magneta wich should be "magenta"

[@komaljaswani7497]

I woked with "yellow" & "Magenta" & they worked for me on VBA. Thats what I was confused seeing yellow as yello. I thought may be yello works on VBA. Thus I tried it on VBA & yellow worked for me well. :)

[@AkshaySingh-jl1xy]

Why it is "Yello" instead of "Yellow" There is one more method Range("a1:a10").font.color = RGB (0,255,0)

[@runwaycoach6442]

*Magenta

[@komaljaswani7497]

Correct

[@karthickrajalearn]

Sub font_color() Range(a1:a10).Font.Color=vbGreen(Total 8 standard Color) Range(a1:a10).Font.ColorIndex=1(1-56) End Sub vbWhite vbBlack vbYellow vbRed vbCyan vbBlue vbMagenta

[@komaljaswani7497]

Hi Pawan! Its not Magneta, its Magenta!! Thats what I was thinking of!! Because I know Magenta colour which means dark pink.

[@komaljaswani7497]

It threw error when I used "Magneta". & Yello is yellow ok! :)

[@ammarkhan2611]

It should be Magenta instead of Magenta

[@komaljaswani7497]

U wrote both spellings correct buddy! :) Pawan used Magneta & not Magenta. ;)

[@yaahoomail]

2 spelling errors - yello and magneta should be corrected to yellow and magenta.. also they are pronounced as yell-o and ma-gent-a..