conditional formatting via check box

[vttech]

I have a userform called frmLeaveRequest that contains a check box named chkVac, I want to pass the conditional formatting of Bold, Red Font and a Border around the contents in Cell C9 in an Execl doc called LRForm.xls in worksheet LeaveRequested when chkVac equals true. How do I accomplish a task like that??


Newbie in search of knowledge

 

[vttech]

I used

Public sub ConditionalFormat()
Range("c9").Borders.Color = RGB(255, 0, 0)
Range("c9").Borders.Weight = xlThick

End sub

but know I don't know how to turn the cell back to it's orginal state. which was no formating. need a some hints, ideas thanks

Newbie in search of knowledge