QP School › Tutorials › Excel VBA Tutorials v
Formatting cells with VBA

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Formatting cells with VBA
Qomplainerz Offline
Administrator
*******
Posts: 4,488
Threads: 4,488
Joined: Aug 2020
Reputation: 0
#1
07-27-2023, 06:31 AM
Description:

You can format cells using various properties of the Font and Interior objects.

Example:

Sub ExampleFormattingCells()
    Range("A1").Font.Bold = True
    Range("A1").Interior.Color = RGB(255, 255, 0)
End Sub
Also follow me on Youtube for videos about video games:
https://www.youtube.com/channel/UCxfkGVU...2mQ/videos
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Format cells in a range with bold font and yellow background color Qomplainerz 0 1,460 07-27-2023, 11:26 AM
Last Post: Qomplainerz
  Split text in cells with VBA Qomplainerz 0 1,038 07-27-2023, 11:09 AM
Last Post: Qomplainerz
  Count colored cells with VBA Qomplainerz 0 947 07-27-2023, 11:07 AM
Last Post: Qomplainerz
  Calculate the avg and color the cells when their values are above or below the avg Qomplainerz 0 1,006 07-27-2023, 10:41 AM
Last Post: Qomplainerz
  Protect specific cells with VBA Qomplainerz 0 1,007 07-27-2023, 10:39 AM
Last Post: Qomplainerz
  Format cells with conditional formatting in VBA Qomplainerz 0 932 07-27-2023, 08:16 AM
Last Post: Qomplainerz
  Loop to fill numbers in cells with VBA Qomplainerz 0 1,001 07-27-2023, 08:16 AM
Last Post: Qomplainerz

Forum Jump:


Users browsing this thread: 3 Guest(s)