Share via

Conditional Formatting Formula Help

Anonymous
2016-10-30T21:43:48+00:00

Hi I need help with conditional formatting and trying to figure out what formula to use for a problem I have. 

Problem: Create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sale price.

I uploaded a picture of the table below. I just need help with what formula to put. Thank you!!

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2016-10-30T22:03:13+00:00

    Do you mean where the sale price is less than or equal to 70% of the sticker price?

    Select D2:D30 (or however far down as the data go).

    I will assume that D2 is the active cell within the selection.

    On the Home tab of the ribbon, select Conditional Formatting > New Rule...

    Select 'Format only cells that contain'.

    Leave the first dropdown set to the default 'Cell Value'.

    Select 'less than or equal to' from the second dropdown.

    In the box next to it, enter the formula

    =70%*C2

    Click Format...

    Activate the Font tab and specify Bold.

    Activate the Fill tab and select yellow.

    Click OK, then click OK again.

    Was this answer helpful?

    90+ people found this answer helpful.
    0 comments