Posted on 2014-11-13
I have 5 columns, with a header.
There are two basic types of rows - those that have a code of XXXXXX-00 and those that don't.
I want all of these rows (entire row) to be a distinguishable color and the alternates to be some slightly different color.
I could get it working with just the leading cell (col A) only, but it wouldn't highlight the entire row.
Is there a way to setup conditional formatting to do this? Wanted to stay away from a macro solution if possible...