Grey out an entire row in Excel 2010 depending on a cell's value
Solved/Closed
deeptis
Posts
6
Registration date
Thursday June 19, 2014
Status
Member
Last seen
July 25, 2014
-
Updated on Jan 30, 2019 at 06:31 AM
T - Aug 11, 2021 at 11:28 PM
T - Aug 11, 2021 at 11:28 PM
Hi all,
I am trying to grey out an entire row in excel 2010 depending on a cell's value.
Each cell has a drop down list: Yes, No, Maybe etc
I want the entire row going forward, to only be greyed out if a cell indicates the value No. and the row remains active if other options are selected.
I look forward to hearing your thoughts.
Thanks
Dee
I am trying to grey out an entire row in excel 2010 depending on a cell's value.
Each cell has a drop down list: Yes, No, Maybe etc
I want the entire row going forward, to only be greyed out if a cell indicates the value No. and the row remains active if other options are selected.
I look forward to hearing your thoughts.
Thanks
Dee
Related:
- How to gray out cells in excel
- Number to words in excel - Guide
- Gif in excel - Guide
- How to take screenshot in excel - Guide
- How to calculate position in excel ✓ - Office Software Forum
- How to open excel in notepad - Guide
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 1, 2014 at 11:01 AM
Jul 1, 2014 at 11:01 AM
Here it is:
![](https://img-16.ccm2.net/jrSGLQU4I6_1RIG35qwZxBRRipk=/2f360d0efba748e9804730139cd504d7/ccm-ugc/4r18SksTYe5JqvRztOsDGJVZdFZ-dee-2-s-.png)
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
![](https://img-16.ccm2.net/jrSGLQU4I6_1RIG35qwZxBRRipk=/2f360d0efba748e9804730139cd504d7/ccm-ugc/4r18SksTYe5JqvRztOsDGJVZdFZ-dee-2-s-.png)
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Jul 25, 2014 at 06:53 AM
Jul 28, 2014 at 11:29 AM
So you want to grey out the entire row whenever "Complete" is found within that row at any location. Then use this formula:
=ISNUMBER(MATCH("Complete",1:1))
Best regards,
Trowa
Updated on Aug 11, 2021 at 11:38 PM
works.