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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 22, 2018 at 04:55 AM
Related:
- Row conditional formating in Excel
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Marksheet format in excel - Guide
- Saints row 2 cheats - Guide
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 22, 2018 at 04:55 AM
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
Glad to have helped you.
Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Feb 22, 2018 at 03:17 AM
Yes it worked perfectly....thank you very much for your quick response
Christos