I need to explain this better
Can I do this in VB6 for a CALC cell
Code: Select all
If Format(Date, "dddd") = "Friday" Then
oSheet.GetCellRangeByName("E6").Formula = "=fontweight.Bold"
End If
OK, so I know that what I wrote after the = sign in not correct. I already have some data in that cell. Without destroying that data, I want to make the font bold.
And, when I have data i n a cell, and I already have a formula there (such as adding some other cells, can I place another formula there, without destroying the data and first formula? In this case I may need additionally making the call contents bold (it is Friday) and maybe changing the color to red (the value less than the value in cell above it.
Thanks