Share via

Conditional formatting w/ % difference

Anonymous
2020-10-23T11:41:07+00:00

I have 2 tables of data - one forecasted values, one actual values. I am trying to create Conditional Formatting to have the actual values highlight if they are greater than 10% of the forecasted values. Can anyone help?

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
    2020-10-23T12:30:29+00:00

    Let's say the forecast values are in C2 and down, and the actual values in D2 and down.

    Select the range with actual values; I will assume that D2 is the active cell in the selection.

    On the Home tab of the ribbon, click Conditional Formatting > Highlight Cells Rules > Greater Than...

    Enter =10%*C2 in the box, then click OK or press Enter.

    If you actually meant to highlight actual values that are at least 10% higher than the forecast values, use =110%*C2 instead.

    Was this answer helpful?

    0 comments