HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Colour Excel Cells, Font and Border with VBA Macro

48,470 views October 31, 2018 9:47

Watch on YouTube
ChannelChester Tugwell

Description from the creator

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
paypal.com/donate/?hosted_button_id=CGKRY2BAYEQ…
Thank you! 👍👍
This video demonstrates how to write a VBA macro that will:

Change the background colour of a cell,
Change the font colour
Change the border colour.

You can specify colour in a number of ways in VBA including built in vb colours and built in rgb colours You can also specify RGB colours using your own red, green and blue values.
------------------------

About this tutorial

Chester Tugwell published this 9:47 video tutorial on October 31, 2018. It has been watched 48,470 times on YouTube.

Duration
9:47
Published
October 31, 2018
Views
48,470
Likes
252

Tags

Share

This tutorial in other languages