Hi,

This is a bit confusing but try this in D1 and drag down as required. You
can then use conditional formatting on D1 to set the cell/font colour you
want depending on the result.

=IF(C1-B1<=0,A1,"")

Mike

"Coco212" wrote:

How do I write a function to subtract one row/column cell from one other
row/column cell, comparative by location, such as the cell on the same row
but the column before it?
or after it?
then change the cell color?
and font color?
then tell to "use another cell " if the value is a negative number?

Something like,
=if (same row, column to the left)-(same row, column two columns over to the
left)"greater than" (ten or more greater than) then turn cell dark red and
turn font white,
and
=if (same row, column to the left)-(same row, column two columns over to
the left)"greater than" = < "zero" enter text "Use cell in (threes columns
to the left, same row)
Thanks,
Syndy