an additional Conditional Format

[shaftdx]

I don't even know how to word this, but here we go. I am trying to make a spreadsheet for our Fuel for the company I work for. I have 3 conditional formatting formulas already in place that turn the row a different color if the conditions are met. I need a formula so that if a cell in column "G" is different that the same in column "D" it will let me know. I think it is an IFTHEN statement but I have no idea.

 

[Fluff]

How about

=G2<>D2

 

[shaftdx]

How about

=G2<>D2

I spent yesterday and part of today trying to make this work, and it is not. I so not get it. Almost everything highlighted. I don't know if there is something wonky with the calculation I have or what.

 

[Joe4]

What range are you selecting before you are applying the Conditional Formatting formula?
Note that you need to write it as it applies to the first cell in your selected range.
You will also want to lock down the column references, if you are selecting multiple columns, i.e.

=$G2<>$D2

 

[Fluff]

If you have formulae in either of those columns, it's probably a rounding error
Try

=ROUND(G3,2)<>ROUND(D3,2)