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

Question

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

Report

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

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

The formula should be simple A+B=C,true or false but nope?
Excel formula to compare two columns and return a value true or false ✓ - Forum - Excel
The simple Excel formulas (calculation VAT inclusive) - How-To - Excel
Excel (all versions) - How to copy a simple formula? - How-To - Excel
Simple Excel Formula Help ✓ - Forum - Excel
Simple function or formula I think ✓ - Forum - Office Software

1 reply

Ask a question

Blocked Profile · Answer 1 · 2017-06-09T16:35:07-0400

Answer 1 / 1

Blocked Profile
Jun 9, 2017 at 04:35 PM

You are describing conditional formatting. Take a look at this:

https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color

Your reply