Row conditional formating in Excel [Solved/Closed]

Report
Posts
14
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 26, 2021
-
Posts
1884
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 26, 2021
-
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
1884
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 26, 2021
139
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 2942 users have said thank you to us this month

Posts
14
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 26, 2021

Good Morning,

Yes it worked perfectly....thank you very much for your quick response
Christos
Posts
1884
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 26, 2021
139
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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!