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
0
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