Hello Paul,
Hope you are doing great today!
thank you for the pointers.
I was just wondering, does the font need a name? I could not find a column for the font name.
I have attached the updated spreadsheet - I think its starting to look a bit better now.
For the RGB I would need to add the code below
Code:
Dim xlRGB
xlRGB = xlRGB & "|" & Trim(.Range("M" & i))
If Split(xlRGB, "|")(i) <> "" Then .Color = Split(xlRGB, "|")(i)
If Split(xlRRGB, "|")(i) <> "" Then .Size = Split(xlRRGB, "|")(i)
I managed to figure out the True / False bit - when I ran the VBA sadly it did not do anything -
knowing me as usual - I probably don't have the correct font name as there was not a column for the font name, or am confusing things.
In the document I am testing it on -
The font is : Times New Roman Bold 16
I am really
excited I can see the
endless possibilities - but I need to get the spreadsheet working first -
Thank you for helping me again
J