Formatting based on length of data in cell?

[Davest11]

I'm building a spreadsheet in Excel 07 that will be used as a datasource for a Crystal report. There's a column where every cell must be a six-character string. Where the actual data is not six characters long, the data will be preceded by leading spaces to pad the field to six characters. As the spreadsheet will be populated by hand, this is a perfect breeding ground for typos.

What I'd like to do is set up some sort of rule where, if the contents of the cell is less than six characters, the color of the text would change. Is this possible in Excel?

Thanks,

-Dave

 

[Davest11]

Nevermind...I found it exactly 23 seconds after I posted this.