Formula help, compare amount in two cells

2

29kilo

Thanks in advance for any help:

I want to compare the amounts in two separate columns. If
the amount in cell c4 is less than the amount in cell c6,
then subtract c4 from c6 and put the result in c5 and
color it red.
I know this is simple but I just can't get it to work.
Any help is really appreciated.
 
C

CLR

In C5 put

=IF(C4<C6,C6-C4,0)

Then click on C5 and do Format > Conditional Format > Formula Is > =$C$5>0
and select Format > Patterns > and select Red color > OK > OK

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The sum of the same function that is used for a range of cells 2
Fill Series in Filtered Rows 2
Fill Series Calculations with Autofilter ON 0
change cell color depending on two cell values 1
if then formula 4
Count matching data 5
Copy addition formula of non-consecutive horizontal cells 2
= cell above last entered data 9

Top