IF Function Help

[chasecollier]

Probably a simple solution to this but I am new to functions so..

I need to write out an IF function to for conditional formatting. In English it goes like this..
IF the difference between G33 and F33 is greater than 20, highlight in red.

Im sure one of you excel masters probably can write this function in your sleep..

 

[63falcondude]

Assuming that you know how to use conditional formatting, try

=ABS(G33-F33)>20

Format Red Fill.

 

[chasecollier]

Worked flawlessly!

 

[63falcondude]

Great! Glad to help.