CODEWITHSUNDEEP
excelexcel-formulahighlightconditional-formatting
Mitesh Agrawal
Mitesh Agrawal

Reputation: 87

How to highlight a cell with reference to another cell?

Someone please help me to write an excel formula to achieve the requirement mentioned in the subject line.

I want to get a cell highlighted if the cell value is 50% or higher than the cell value to the left.

80 180

In the above case of two numbers, 180 should be highlighted.

Please help.

Regards, Mitesh Agrawal

Upvotes: 0

Views: 978

Answers (1)

Excel Hero
Excel Hero

Reputation: 14764

Assume cell A1 has the value of 80.

Assume cell B1 has the value of 180.

Select cell B1.

On the Ribbon, click Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format.

Enter the following formula:

=B1>=(A1+A1*0.5)

Click the Format button and then click on the Fill tab to select the color you want.

Upvotes: 1

Related Questions