Different between cells

Question

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

Answer 1

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.

---