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
Related:
- How to gray out cells in excel
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- How to change author in excel - Guide
- How to change date format in excel - Guide
- 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:
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
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.