Row conditional formating in Excel [Solved/Closed]

Report
Posts
13
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 24, 2019
-
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
Hi All,

I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text.
There is solution around it?

Thanks

2 replies

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
christossol, Good morning.

Try to use:

Select desired row: A5:X5 (as your necessity)

Conditional Format Menu --> Using Formula -->

Type: =$G$5="YES" (It's an example only)

Format Fill Color as desired --OK

Is that what you want?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3210 users have said thank you to us this month

Posts
13
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 24, 2019

Good Morning,

Yes it worked perfectly....thank you very much for your quick response
Christos
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Christos, Good morning.

Glad to have helped you.

Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3210 users have said thank you to us this month