Row conditional formating in Excel

Solved/Closed
christossol Posts 15 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022 - Updated on Mar 2, 2018 at 03:01 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 22, 2018 at 04:55 AM
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
Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 21, 2018 at 06:27 AM
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
christossol Posts 15 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022
Feb 22, 2018 at 03:17 AM
Good Morning,

Yes it worked perfectly....thank you very much for your quick response
Christos
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 22, 2018 at 04:55 AM
Christos, Good morning.

Glad to have helped you.

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