Conditional formatting excel

Hi

Can someone please advise the easiest way to colour rows which have a specific name in a column in excel. I have tried using conditional formatting but it only colours the cells not the full rows.
Gwynneth TaylorAsked:
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.

ShumsDistinguished Expert - 2017Commented:
Assuming your text is in G Col and you want to highlight from A to M. Try below:
=INDIRECT("G"&ROW())="Gwen"

Open in new window

Change the text Gwen with the text you want for conditional formatting.
Apply range from A1:M20 or whatever range you may have
Check below image:
Conditional Formatting
2

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
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
I have tried using conditional formatting but it only colours the cells not the full rows.
just use the Format Painter and paint it across the whole rows
1
Rgonzo1971Commented:
Hi,

or you could simply use
=$G1="Word"

Open in new window

1 is for the first row applied to
and apply to the whole row
for example =$1:$25

Regards
0
Gwynneth TaylorAuthor Commented:
Excellent thank you. Worked first time.
0
ShumsDistinguished Expert - 2017Commented:
You're Welcome Gwynneth! Glad I was able to help.
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.