Report

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

Ask a question excelhelpp 1Posts Friday June 9, 2017Registration date June 9, 2017 Last seen - Last answered on Jun 9, 2017 at 04:35 PM by ac3mark
Hello,
i need formula help please!
i am working with three columns of data.

if:
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

See more 
Helpful
+0
plus moins
You are describing conditional formatting. Take a look at this:

http://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!