check two cells against another two cells

[pallet48]

hello,

i wish to check two cells against another two , eg A1 +B1 equal to C1 + B1


cheers


stu

[sweep]

Hello,

Try this =A1&B1=C1&D1

Returned TRUE means they're the same, returned FALSE means they're not!

[popipipo]

Please Login or Register  to view this content.

or maybe this?

[sktneer]

If you don't want to populate an extra column with a formula, you can achieve this with the help of condition formatting. Using the rule given below, you can highlight the rows where values in col. A and col. B are not equal to col. C and col. D. To do so, follow these steps.....

Select the range A2:D101 --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> in the formula box below "Format Value where this formula is true" --> Paste the formula given below --> Format --> Fill --> select the color of your choice --> OK

Please Login or Register  to view this content.

This will highlight the rows where values in col. A and B are not matching with values in col. C and D.

Is this what you are trying to achieve?

[pallet48]

Hello,

Try this =A1&B1=C1&D1

Returned TRUE means they're the same, returned FALSE means they're not!

thanks works great

[pallet48]

If you don't want to populate an extra column with a formula, you can achieve this with the help of condition formatting. Using the rule given below, you can highlight the rows where values in col. A and col. B are not equal to col. C and col. D. To do so, follow these steps.....

Select the range A2:D101 --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> in the formula box below "Format Value where this formula is true" --> Paste the formula given below --> Format --> Fill --> select the color of your choice --> OK

thanks works great . thanks for your time and effort and knowledge

Please Login or Register  to view this content.

This will highlight the rows where values in col. A and B are not matching with values in col. C and D.

Is this what you are trying to achieve?

thanks works great . thanks for your time and effort and knowledge

[pallet48]

thanks works great . thanks for your time and effort and knowledge

[sktneer]

You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.