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
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
Related:

4 replies

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Jul 1, 2014 at 11:01 AM
Here it is:


Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
3
deeptis Posts 6 Registration date Thursday June 19, 2014 Status Member Last seen July 25, 2014
Jul 25, 2014 at 06:53 AM
but what would I need to do if cell A1 was not complete but B1 was complete, I would need the formula to be transfer across the entire row and skip to the next cell if the outcome was not complete.
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Jul 28, 2014 at 11:29 AM
Hi Dee,

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
0
Thank you, formula =$B2="Complete"
works.
0