Closed Thread
Results 1 to 7 of 7

highlight the rows in RED using conditional formatting according to the selection in the v

  1. #1
    Registered User
    Join Date
    10-21-2019
    Location
    new delhi
    MS-Off Ver
    office 2019
    Posts
    2

    highlight the rows in RED using conditional formatting according to the selection in the v

    Task 3: In the below dataset; highlight the rows in RED using conditional formatting according to the selection in the validation controls
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 10-21-2019 at 07:38 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: How to solve Q3 and Q6

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    As you are new here I will do it for you this time. Please read forum rules

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: highlight the rows in RED using conditional formatting according to the selection in t

    Also, nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    10-21-2019
    Location
    new delhi
    MS-Off Ver
    office 2019
    Posts
    2

    Re: highlight the rows in RED using conditional formatting according to the selection in t

    I have completed the 2 parts in Q3 but in third part i am unable to connect the drop down list to the data validation, i have searched the internet and tried many formulas at last i came here just to know how to do these questions because completing the case studies are not mandatory.

  5. #5
    Registered User
    Join Date
    05-08-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    2

    Re: highlight the rows in RED using conditional formatting according to the selection in t

    i am also facing the same issue

  6. #6
    Registered User
    Join Date
    05-08-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    2

    Re: highlight the rows in RED using conditional formatting according to the selection in t

    hi i am also working on this file but there are two question's Q7 (1st is solved) & Q3.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: highlight the rows in RED using conditional formatting according to the selection in t

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove Duplicates and Locate only Newly inserted Datas
    By maddyrafi1987 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-15-2017, 08:08 AM
  2. [SOLVED] Solve for X?
    By mitch22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2014, 12:17 PM
  3. Who can solve that?
    By excelfoum123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-19-2014, 06:40 PM
  4. Please solve this
    By loki7431 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2013, 10:58 AM
  5. How do I solve for n in =4^n=64
    By dpiekarz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2006, 05:39 PM
  6. y i cannot solve it ?
    By cjjoo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2005, 07:05 AM
  7. [SOLVED] How to solve?
    By Lee Tow in forum Excel General
    Replies: 2
    Last Post: 06-24-2005, 08:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1