Solved

Status Change in Row

Posted on 2012-03-21
1
147 Views
Last Modified: 2012-03-22
Hi,

In the attached spreadsheet, column G has a option of Open / Closed which can be selected.

When 'Closed' has been selected, the row from B3 to G3 needs to change colour to grey.

What I also noticed that the colour has no impact on cell B3.  If possible the colour needs to change to Grey, but the wording needs to stay the same

Then if possible:

If I change B3 to say Open, the Grey needs to go away, and if cell B3 says Green, it needs to change to Green fill

Hope this makes sense

Eddie
experts-1b.xlsx
0
Comment
Question by:propolis
1 Comment
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
ID: 37751094
As requested.

See conditional formatting in the attached.  Basically, you select cell G2, then create a conditional formation based on formula =$G2="Closed" and set the fill to grey, then edit the conditional format and change the apply to =$B$2:$G$10.  From that point, any closed cell in G2:G10 space will grey that row from B to G.  If changed to something else besides "Closed" the conditional format is "off" and thus the formatting for column B reverts.



Cheers,


Dave
experts-1b.xlsx
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now