Different between cells

BT 160 Reputation points

When the value of D5 is greater than 10% of the value of C5, the D5 value automatically turns red.

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,100 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,326 Reputation points

    Hi @BT

    Do you want the conditional format formula?

    If there are only two cells D5 and C5 compared, you may refer to the formula: =$D$5>$C$5*0.1, and set the font to be red.


    If there are multiple rows of cells in C column and D column to be compared, you may try formula: =$D5>$C5*0.1, and apply the formula to the cells in D column, set red for their font.


    Any misunderstandings, please feel free to let me know.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful