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 grey out cells in excel
How to gray out cells in excel - Best answers
Grey out cells in excel based on value - Best answers
Automatically copy cells in excel to another sheet - Guide
Blinking cell in excel without macro ✓ - Forum - Excel
If cell color excel - Guide
How to screenshot selected cells in excel - Guide
How to disable a cell in excel based on condition vba ✓ - Forum - Excel

4 replies

Answer 1 / 4

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.

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

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 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
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 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
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

Duplicate rows based on cell value

Deleting Rows with Negative Numbers

Code to move rows into another sheet based on certain values

Copy rows to other sheets based on value in column

Create new sheets based on Column A data.

Insert multiple copied rows at fixed intervals

Similar discussions

Subscribe To Our Newsletter!