Row conditional formating in Excel [Solved]

christossol 11 Posts Friday February 17, 2017Registration date February 22, 2018 Last seen - Feb 21, 2018 at 03:25 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- 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
See more 

Your reply

3 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 21, 2018 at 06:27 AM
1
Thank you
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1826 users this month

christossol 11 Posts Friday February 17, 2017Registration date February 22, 2018 Last seen - Feb 22, 2018 at 03:17 AM
Good Morning,

Yes it worked perfectly....thank you very much for your quick response
Christos
Respond to Mazzaropi
Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 22, 2018 at 04:55 AM
1
Thank you
Christos, Good morning.

Glad to have helped you.

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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1826 users this month

Respond to Mazzaropi