The formula should be simple A+B=C,true or false but nope?

excelhelpp Posts 1 Registration date Friday June 9, 2017 Status Member Last seen June 9, 2017 - Jun 9, 2017 at 01:13 PM
 Blocked Profile - Jun 9, 2017 at 04:35 PM
i need formula help please!
i am working with three columns of data.

cell A1=B9904
cell B2=A2399B
then cell C2 needs to =B9904 A2399B

if it doesnt equal, i would like it highlighted.

thats all. i have thousands of lines and right now i am just manually trying to visually spot check. help please


1 response

Blocked Profile
Jun 9, 2017 at 04:35 PM
You are describing conditional formatting. Take a look at this: