I am using Excel 2000.
Can I create a button to automatically set some formatting changes to a spreadsheet?
I'm trying to set the font size, printer and gridlines.
I would also like to change the font color using an IF statement (if cell value like "*closed*" then Cell value.FontColor =red.).
I'm new to programming with Excel.
Thanks!
Can I create a button to automatically set some formatting changes to a spreadsheet?
I'm trying to set the font size, printer and gridlines.
I would also like to change the font color using an IF statement (if cell value like "*closed*" then Cell value.FontColor =red.).
I'm new to programming with Excel.
Thanks!