asked on

Conditional formatting

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...

ASKER CERTIFIED SOLUTION

Tom Farrar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sirbounty

ASKER

I thought I had the first column working, but now it's highlighting the opposite data.
My formula is
=RIGHT($A2,3)="-00"
but these cells don't get highlighted as I've set it... : \

sirbounty

ASKER

Weird - even setting the formula to =A2 doesn't change that single cell... wonder if I've done something somewhere... :(

sirbounty

ASKER

Somehow I fixed that, but it's still not formatting the rows... still trying.

sirbounty

ASKER

Ok, I've determined that setting a conditional format formula fails:
=RIGHT(TRIM($A$2),3) (just trying to grab the "-00" which doesn't seem to work either.

If I use the text, ends with =RIGHT(TRIM($A$2),3), it will highlight the first column, but even selecting the range does not format the rows...

sirbounty

ASKER

=RIGHT(TRIM($A2),3)="-00" finally worked for me - had that extra $ in there...oops. :^)

Tom Farrar

RIGHT(TRIM($A$2),3)...... Your $A$2 is selecting only A2.