Excel

Anonymous
2020-11-08T20:32:35+00:00

Trying to create a formula based formatting rule to format the dates in column A as bold with dark red text and light red fill when the profit margin in Column G is <40%

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-11-08T23:06:32+00:00

    Thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-11-08T22:47:50+00:00

    Hi, I'm Elise, an independent advisor and I'd be happy to help with your issue.

    There is a very good tutorial here which explains how to setup a formula for conditional formatting based on another cell.

    Once you have your formula setup, you just pick how you want the target cell formatted.

    https://www.excel-university.com/excel-conditio...

    Please let me know if you need any further assistance.

    Kind Regards,

    Elise

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-11-08T21:31:56+00:00

    Hi 

    Assuming row 1 is for the headers and Data is from row 2 downwards 

    1-Select on column A range A2:A####

    2-and use this formula for the conditional formatting

    =$G2<40%

    I hope this helps you

    Regards

    Jeovany

    Was this answer helpful?

    0 comments