Color Xlnone at Color

Color Xlnone. Private sub worksheet_selectionchange(byval target as excel.range) application.screenupdating = false cells.interior.colorindex = xlnone activecell.entirerow.interior.color = rgb(255, 145, 145) Expression a variable that represents a border object.

Download Excel Vba Color Index Gantt Chart Excel Template
Download Excel Vba Color Index Gantt Chart Excel Template from gantt-chart-excel.com

The following line of code removes the fill color of the cell a1: In the code, chekbox1 is the name of the check box (activex controls). You can change it as you need.

Download Excel Vba Color Index Gantt Chart Excel Template

Then click insert > module, and copy the below vba code 2 into the module window. Expression a variable that represents a border object. C.entirerow.interior.color = vbyellow elseif ucase(c.value) = overdue then c.entirerow.interior.color = vbred else c.entirerow.interior.color = xlnone end if next end sub. Then click insert > module, and copy the below vba code 2 into the module window.