Grey out an entire row in Excel 2010 depending on a cell's value

Solved/Closed

Excel

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

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 open excel in notepad - Guide
How to change date format in excel - Guide

4 responses

Answer 1 / 4

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

T
Updated on Aug 11, 2021 at 11:38 PM

Thank you, formula =$B2="Complete"
works.

Answer 4 / 4

deeptis Posts 6 Registration date Thursday June 19, 2014 Status Member Last seen July 25, 2014
Jun 20, 2014 at 06:29 AM

thank you Trowa, but how can I format the entire row based on a result from a previous cell?

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 23, 2014 at 10:57 AM

Hi Dee,

Since I'm using Excel 2003, I can't tell you from personal experience.

So let me provide you with a link which shows both a video and text of what you are trying to achieve:
https://www.contextures.com/xlcondformat02.html

Best regards,
Trowa

deeptis Posts 6 Registration date Thursday June 19, 2014 Status Member Last seen July 25, 2014
Jun 24, 2014 at 09:28 AM

thanks for this.

I am trying to track progress of a projects, so each week an option is selected until the option 'complete' is selected, once that has been selected, I want the entire row to the right of the 'completed' cell to go grey.

Is this possible?

Thanks
Dee

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 24, 2014 at 12:02 PM

Hi Dee,

In the example they use the formula =$B2>75. You will want to use the formula =$B2="Complete".

Best regards,
Trowa

deeptis Posts 6 Registration date Thursday June 19, 2014 Status Member Last seen July 25, 2014
Jun 24, 2014 at 12:28 PM

thank you, but how do I ensure the entire row is then formatted? at the moment it is only the cell below the 'completed' cell that is formatted?

Similar discussions

Copy data onto sheet only if cell has text

Excel if range of cell contain a text put a cell value in

Compare values in two columns and return the value from third

Excel - IF function with multiple words

Code to move rows into another sheet based on certain values

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!