I found out that when this rate is changed it changes rates throughout the
workbook and I won't know what has changed if I don't have the rate in a
different color.

"CBW" wrote:

We have a little program we run in Excel and it was created in Excel 97. We
all have Windows XP and Office 2000 or 2003.

When I go in to make a change, for example I click a button named "New" to
change a dollar amount. After I change the dollar amount I click another
button named "Submit". It's when I click the submit button that I get the
error message.

Run-Time error '1004':
Unable to set the ColorIndex property of the Font Class

When I click on the "Debug" button it takes me to where the error is but I
don't know how to correct it. Below is a sample of where the "Debug" takes
me in Visual Basic.

Sheets("Rate Sheet").Range("H18:H82").Font.ColorIndex = 11

Can I just change the "=" to another color value and how do I found out what
the color value number is?

Thanks!