Home » Forums » Open Source Learning Center » Question and Answer

How do I highlight a group of cells?

Submitted by andyaf on 4 June, 2013 - 00:15

HI,

I've created a table and have to make one portion of the table "stand out" (aka I have to add some sort of a glow effect). I did not use the table function on excel, I hard coded all the data. Is there any way I can make a group of cells "Stand out" or glow when compared to the others?

Thanks a bunch!

‹ Calculate absolute time difference between two dates and times while excluding weekends and non-working hours. Importing specific cells from several workbooks into a new workbook ›
»

Color on your cells

Submitted by cati.pt on 6 June, 2013 - 05:03.

I am not sure if you just want to add a color on the range, but if yes it is pretty simple!

ex: Range("A1:A12").Interior.Color = vbYellow

You just write it on VBE and Excel will paint the range(A1:A12) with yellow color :)

If you are not used to Excel VBA just tell me send me the table and I will send you the perfect code you need.

Good job!
Cátia Santos

»

Color on your cells

Submitted by cati.pt on 6 June, 2013 - 05:03.

I am not sure if you just want to add a color on the range, but if yes it is pretty simple!

ex: Range("A1:A12").Interior.Color = vbYellow

You just write it on VBE and Excel will paint the range(A1:A12) with yellow color :)

If you are not used to Excel VBA just tell me send me the table and I will send you the perfect code you need.

Good job!
Cátia Santos

»