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

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
Here it is:


Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
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.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
Thank you, formula =$B2="Complete"
works.

Similar discussions