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...
LVL 67
sirbountyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tomfarrarCommented:
http://www.howtogeek.com/howto/45670/how-to-highlight-a-row-in-excel-using-conditional-formatting/

See paragraph starting with:

"Now that we have a working formula, let’s apply it across our entire table. As you can see above, the formatting applies only to the cell we started off with. Click the button next to the Applies to field and drag the selection across your entire table."
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProfessorJimJamCommented:
You need to select the entire region then put the formula, your formula doesn't work because you didnot select the entire region I mean entire rows
0
NorieVBA ExpertCommented:
Select all the rows.

Goto conditional formatting.

Select Use formula to...

Enter this formula, changing 2 to the first row in the rows you selected.

=$A2=" XXXXXX-00"

Format as required.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

sirbountyAuthor Commented:
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... : \
0
sirbountyAuthor Commented:
Weird - even setting the formula to =A2 doesn't change that single cell... wonder if I've done something somewhere... :(
0
sirbountyAuthor Commented:
Somehow I fixed that, but it's still not formatting the rows... still trying.
0
sirbountyAuthor Commented:
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...
0
sirbountyAuthor Commented:
=RIGHT(TRIM($A2),3)="-00" finally worked for me - had that extra $ in there...oops. :^)
0
tomfarrarCommented:
RIGHT(TRIM($A$2),3)......  Your $A$2 is selecting only A2.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.