Row conditional formating in Excel
Solved/Closed
christossol
Posts
15
Registration date
Friday 17 February 2017
Status
Member
Last seen
23 March 2022
-
21 Feb 2018 à 03:25
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Feb 2018 à 04:55
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Feb 2018 à 04:55
Related:
- Row conditional formating in Excel
- How to change date format in excel - Guide
- Saints row 2 cheats - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel clear formatting - Guide
- Arrow keys not working in excel - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
21 Feb 2018 à 06:27
21 Feb 2018 à 06:27
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
22 Feb 2018 à 04:55
22 Feb 2018 à 04:55
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
22 Feb 2018 à 03:17
Yes it worked perfectly....thank you very much for your quick response
Christos