+ Reply to Thread
Results 1 to 6 of 6

Help with condititonal formatting

  1. 09-09-2022, 10:42 AM #1
    Suhayl
    Suhayl is offline
    Registered User
    Join Date
    09-09-2022
    Location
    Zambia
    MS-Off Ver
    MS Office Professional plus 2016
    Posts
    7

    Post Help with condititonal formatting

    Here's the scenario. I have a master price list. Each product has a wholesale and retail price. But different products have different markups for wholesale and retail. So, for example, if I have 2 products A and B, product A could have a retail markup of 20% and product B could have a retail markup of 30%. I want to set up conditional formatting in such a way that if a cost of a product is multiplied by the 30% markup, it should highlight the cell green, and if it's multiplied by a 20% markup, it should highlight the cell blue. So just by looking through my list, I know what the markup is on each product. Let me know if this can be done.
    Reply With QuoteRegister To Reply
  2. 09-09-2022, 11:00 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Help with condititonal formatting

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 09-10-2022, 02:44 AM #3
    Suhayl
    Suhayl is offline
    Registered User
    Join Date
    09-09-2022
    Location
    Zambia
    MS-Off Ver
    MS Office Professional plus 2016
    Posts
    7

    Re: Help with condititonal formatting

    Thanks Pepe. I have attached the worksheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-10-2022, 11:35 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,588

    Re: Help with condititonal formatting

    I put the data in columns K:M so that it could be compared to columns A:C
    The formula for the red conditional formatting rule is: =L2=K2*H$2
    The formula for the amber conditional formatting rule is: =L2=K2*H$3
    The formula for the yellow conditional formatting rule is: =M2=K2*H$4
    The formula for the green conditional formatting rule is: =M2=K2*H$5
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  5. 09-12-2022, 02:48 AM #5
    Suhayl
    Suhayl is offline
    Registered User
    Join Date
    09-09-2022
    Location
    Zambia
    MS-Off Ver
    MS Office Professional plus 2016
    Posts
    7

    Re: Help with condititonal formatting

    Thanks JeteMc. Works like a charm. Appreciate the help.
    Reply With QuoteRegister To Reply
  6. 09-12-2022, 09:06 AM #6
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,588

    Re: Help with condititonal formatting

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2010 - Pivot Table conditional formatting - use multiple rows formatting on one row
    By ofirmarco in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  2. Apply conditional formatting to cells based on formatting of a reference cell
    By Marbleking in forum Excel General
    Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  3. Calendar formatting using conditional formatting (week, month and special days)
    By Vikey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2016, 08:35 AM
  4. Conditional Formatting on a Pivot Table - Formatting Options Icon not showing
    By kmlloyd in forum Excel General
    Replies: 9
    Last Post: 03-07-2016, 10:39 AM
  5. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  6. Formatting Specific String within a Text based on the formatting found in another cell
    By pglufkin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2013, 09:07 AM
  7. Pivot Table graph looses formatting after running formatting macro
    By arthurbr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2011, 04:16 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1