Sakuji
New Member
- Joined
- May 2, 2004
- Messages
- 32
I was kindly given some code to help me with a spreadsheet and now I would like to add to it. When I input data like "LTS" I would like the cell to colour as indicated in the code but I need the font to be white. What do I need to add to the following code to achieve this?
If Target.value="LTS" then
Target.interior.colorindex=3
end if
End Sub
If Target.value="LTS" then
Target.interior.colorindex=3
end if
End Sub