Hi All

This is my first post here.

I use excel at work all the time, but I am having a bit of trouble coming up with a formula for this situation.

Let's say D60, D10, A7, D8 are the cells with the required data, with D60 being the cell to be conditionally formatted.

I want this cell to be conditionally formated based upon:

D60+D10 > A7 only when (D8<A7)

How would I write this in a transposable formula to be dragged across horizontally.

Thanks,