On Friday, January 8, 2016 at 1:02:31 AM UTC-8, Claus Busch wrote:
Hi Pete,

Am Thu, 7 Jan 2016 21:53:00 -0800 (PST) schrieb pete:

I have 3 columns, A, B, and C. Each will accept input of exactly 6 alphanumeric characters. Two of the three must be populated.

The Conditional Formatting is used to highlight columns which are not compliant.

select A1:C to the end
Conditional Formatting:

=SUM(LEN(TRIM($A1:$C1)))<12


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thanks Claus! I wasn't able to get "SUM" working here, but used "SUMPRODUCT" instead, which seems to do the trick :)

thanks again!