Excel function question

[putasolutions]

I know there is a function where if a cell value is greater than that of another, it will highlight it with a cell fill and the value of the difference, but for life of me can't remember what it is.

Any good soul care to jog my memory?

------------------
Of all the things I've lost, I miss my mind the most

[Bin_hex_2000]

Maybe this one??

=IF(logical_test,value_if_true,value_if_false)


Example:
=IF(B4<10000,10%,15%)



------------------
I think, therefore I exist.

[putasolutions]

Thanks Bin-Hex, half way there, now I need it to highlight so if the value is greater, the cell will change colour automatically and if it is less than or equal to it the cell colour remains the same, I think it may have to do with conditional formatting.

Am I going off at the wrong tangent?

------------------
Of all the things I've lost, I miss my mind the most

[Dreamboat]

That's called Format-Conditional formatting. Check it out.

------------------
TheWordExpert

[putasolutions]

Thanks to both Dreamboat and Bin-Hex, Problem solved , and a happy boss too!

------------------
Of all the things I've lost, I miss my mind the most