Hello.
I already have code that puts a */ at the end of a cell's contents if that cell has a value in it. I was wondering if it would be possible to also change the font colour to red as well...? As you can see, I know next to nothing about VBA code....
This is the current code:
Sub addStarAndBackslashToEndofCell()
Dim e As Range
For Each e In Selection
If e.Value <> "" Then e.Value = e.Value & " */ "
Next
End Sub
Many thank-yous to anyone that gives it a go.
I already have code that puts a */ at the end of a cell's contents if that cell has a value in it. I was wondering if it would be possible to also change the font colour to red as well...? As you can see, I know next to nothing about VBA code....
This is the current code:
Sub addStarAndBackslashToEndofCell()
Dim e As Range
For Each e In Selection
If e.Value <> "" Then e.Value = e.Value & " */ "
Next
End Sub
Many thank-yous to anyone that gives it a go.