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

Solved/Closed

Excel

deeptis Posts 6 Registration date Thursday 19 June 2014 Status Member Last seen 25 July 2014 - Updated on Jan 30, 2019 at 06:31 AM
T - 11 Aug 2021 à 23:28

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 a row in excel
How to delete a row in word - Guide
Saints row 2 cheats - Guide
Excel mod apk for pc - Download - Spreadsheets
How to change date format in excel - Guide
Arrow keys not working in excel - Guide

4 responses

Réponse 1 / 4

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
1 Jul 2014 à 11:01

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 19 June 2014 Status Member Last seen 25 July 2014
25 Jul 2014 à 06:53

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 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Jul 2014 à 11:29

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.

Réponse 4 / 4

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

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 12 September 2010 Status Contributor Last seen 27 December 2022 555
23 Jun 2014 à 10:57

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 19 June 2014 Status Member Last seen 25 July 2014
24 Jun 2014 à 09:28

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 12 September 2010 Status Contributor Last seen 27 December 2022 555
24 Jun 2014 à 12:02

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 19 June 2014 Status Member Last seen 25 July 2014
24 Jun 2014 à 12:28

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!